Report printing error

[Guest]

Hi All,
Having a bit of a problem printing reports.

Issue is:

We have a written a report writer that allows the user to select either
individual reports for printing, or print all option.

When single report is sent to the printer no problem, everything prints fine.

When multiple reports sent to printer get the report header and other static
parts but no data?? All of the reports get spooled (a couple of hundred) but
when they print no actual data is output - apart form headers etc..

The underlying queries work fine and have been tested but we cannot get it
work.

Any ideas anybody??????????????????

Any help GREATLY appreciated, thanks in advance

Geoff

 

[SA]

You provide very few bits of information on how you are creating these
hundreds of reports, but the first think that comes to mind is that if you
are filtering your report to specify a specific say company, then the filter
syntax you are using is incorrect. (e.g. if there are alpha characters in
the ID used etc, you've got to concatate the filter value differently than
if it just has numbers.) Also, if you are doing these repeatedly one after
another, but a doevents break in your code between each print job. But
based on the problem experienced I suspect the former is the issue.