Report Does Not Contain Any Records

[Ronald Anusiewicz]

We are having an odd problem. We are creating a purchase order.
I run a script which creates a filter and then runs a report preview.
The report preview comes up on the screen. We look at everything and determine correctness.
We then press the print button in the toolbar.

99% of the time, the report prints fine. But 1% of the time, we get an error message,
"Report Does Not Contain Any Records"

But the preview did contain a record, the correct record.
If there was no record, then I would think the preview would state that message.

Has anyone else ever seen this?

DIM SHARED vcPO_Num AS c
vcPO_Num = parentform:Ptransno.value

query.filter = "Ptransno = Var->vcPO_Num"
query.order = "recno()"
'replace variables in the filter with their actual values	
query.filter = convert_expression(query.filter,"V")

:Report.Preview("PO",query.filter,query.order)

end

[G Gabriel]

Re: Report Does Not Contain Any Records

Whenever I encounter this message, without giving it too much thought and without delving too much into the underlying cause (which I think it's a stack overflow), I close and re-open alpha and everything is well.

[Ronald Anusiewicz]

Re: Report Does Not Contain Any Records

Closing and re-opening alpha does correct the problem. It's just annoying as the report prints. When they grab the paper and look at it, instead of the PO, in the middle of the paper is the message Report Does Not Contain Any Records.

[G Gabriel]

Re: Report Does Not Contain Any Records

You might try and clear or increase the computer cache or try a printer with a larger sprool memory. I never tried any of this as this does not happen that frequently

[MoGrace]

Re: Report Does Not Contain Any Records

Using the query dot variables invokes the 4 query slot rule and may be causing you to lose your query when the slots are filled. Try just defining a filter and order with local variables in your script. Note you don't need to specify an order expression since leaving it blank or undefined defaults to recno().

DIM SHARED vcPO_Num AS c
vcPO_Num = parentform:Ptransno.value

filter = convert_expression("Ptransno = "+quote(Var->vcPO_Num),"V")
:Report.Preview("PO",filter)

end

[Ronald Anusiewicz]

Re: Report Does Not Contain Any Records

I've never heard of the 4 query slot rule. Can you explain?

Call it being lazy, but many times I will use the genie to write code for me.
Sometimes the genie puts in a lot of extra stuff. I will try the following code and see if the problem goes away.

Thanks

''Get 'Value' property of 'Ptransno' in Form 'PO' .
DIM SHARED vcPO_Num AS c
vcPO_Num = parentform:Ptransno.value
query.filter = "Ptransno = " + s_quote(Var->vcPO_Num)

:Report.Preview("PO",query.filter)

end

[MoGrace]

Re: Report Does Not Contain Any Records

You could also try clearing the query.filter variable before resetting it or after the preview runs to force a new query.

Read more here

[DaveM]

Re: Report Does Not Contain Any Records

Don't forget to compact after working on a report.

[Stan Mathews]

Re: Report Does Not Contain Any Records

I've never heard of the 4 query slot rule. Can you explain?

Call it being lazy, but many times I will use the genie to write code for me.
Sometimes the genie puts in a lot of extra stuff. I will try the following code and see if the problem goes away.

Thanks

''Get 'Value' property of 'Ptransno' in Form 'PO' .
DIM SHARED vcPO_Num AS c
vcPO_Num = parentform:Ptransno.value
query.filter = "Ptransno = " + s_quote(Var->vcPO_Num)

:Report.Preview("PO",query.filter)

end

Changing query.filter in this code to any other variable would remove any possible conflict and confusion.

Foo.filter
Nothing.filter
My_report_filter

[Ronald Anusiewicz]

Re: Report Does Not Contain Any Records

Tom Cone and I looked at this and we can't explain why this could happen.
I did simply the code to the following:

''Get 'Value' property of 'Ptransno' in Form 'PO' .
DIM SHARED vcPO_Num AS c
vcPO_Num = parentform:Ptransno.value
:Report.Preview("PO","Ptransno = " + s_quote(Var->vcPO_Num))

end

The preview always works. It's after the print toolbar button is pushed that
the error will sometimes occur. This button is the standard print button that
alpha supplies.

We'll see if this could correct the problem. It happens enough that after a week
I should know whether this fixes the problem or not.

[G Gabriel]

Re: Report Does Not Contain Any Records

It's 16 slots and in reality it allows for a little more.

[MoGrace]

Re: Report Does Not Contain Any Records

16 slots total, but only 4 per table

[Ronald Anusiewicz]

Re: Report Does Not Contain Any Records

Figured out what's going on here finally. The user having the issue would
print the last couple of pages of a multi page report. Then later would try to print
a single page report. They failed to note that Alpha retained the previous print
settings. Alpha doesn't appear to generate an on screen warning message. Instead,
a page gets printed with the message, "Report Does Not Contain Any Records".

Print.PNG

[MoGrace]

Re: Report Does Not Contain Any Records

Hi Ron,
That's odd that the setting was retained - unless they changed the print setup from the file menu instead of the printer prompt. Been there, done that!