View Full Version : On No Data


Stemdriller
07-15-2010, 06:51 AM
I have a multi report that prints of 8 reports.

If one report contains no data, a blank page is produced.

Is there a way I can actually print the report showing the Printed report but thus showing blank fields.

Thanks
Gareth

vbaInet
07-15-2010, 07:10 AM
What do you mean by a "multi report"?

And what does the following statement mean?
Is there a way I can actually print the report showing the Printed report but thus showing blank fields.It's a bit confusing.

Stemdriller
07-15-2010, 07:14 AM
My main report consists of 8 sub reports.

But if one of the reports does not contain any data, it will not print anything.
(Just a blank sheet)

I want that particulaly sub report still to print, even though it will not show any data. I need the empty report to print.

I just read what I put and yes it doesn't make sense does it!

vbaInet
07-15-2010, 07:21 AM
You will somehow need to fill in the non existent records with something. So what you would do is change the JOIN in the sub report's record source to include ALL records from the main report's record source.

Stemdriller
07-16-2010, 01:28 AM
Yes, I am currently trying to figure out if I can display a label reading 'No data applicable' , rather than just a blank page.

I've been trying the 'On No data' to print a different report, when no data has been detected.

You got any tips?

vbaInet
07-16-2010, 02:00 AM
Use a textbox and in the control source:
=IIF([HasData], "", "No data available")