Printing a Report with no Records

[NICKI004]

This may seem like a stupid question but I have searched and cannot find my answer. When a report doesn't contain any records, how do I stop Alpha from printing a page that says "Report does not contain any records"?? I am wasting a lot of paper with reports that my users run daily.

[DaveM]

Re: Printing a Report with no Records

This has been asked many times on the forum if you do a search.

you need to run a query prior to the print(say, from the calling form/browse) to test that there are records.
If there are records then
print
else dontprint and optionally a message box to that effect.

Make sense?

[NICKI004]

Re: Printing a Report with no Records

That does make sense and I can do that... However, I am currently using action scripting to print these reports, which is running the query as it goes. Most of these reports have about 5 reports in one action script.

So there is no option in report properties or the action script itself to turn this off? Like I said, I can write this in xbasic but I was hoping for a way to fix without doing that.

Thanks!
Nicki

[DaveM]

Re: Printing a Report with no Records

You can write the query(ies) in xbasic at action scripting to set a variable for each or all reports then use the if switch to make them not print??

[NICKI004]

Re: Printing a Report with no Records

Okay I can and will do this.

But if you do find out how to turn this off, please let me know. I have a LOT of code to re-write if this is the case and it seems like double-work...

[MikeC]

Re: Printing a Report with no Records

Nicki,

Have you check the settings-->preferences-->reports . There is a warning that can be brought up--unsure if this has an option to prevent a report with not records but worth a try I would think.

[Tim Kiebert]

Re: Printing a Report with no Records

That does make sense and I can do that... However, I am currently using action scripting to print these reports, which is running the query as it goes. Most of these reports have about 5 reports in one action script.

So there is no option in report properties or the action script itself to turn this off? Like I said, I can write this in xbasic but I was hoping for a way to fix without doing that.

Thanks!
Nicki

Make each action that prints a report conditional. Use A5_GET_RECORDS_IN_QUERY(add all the necessary stuff here) >0 in the expression.