On No Data

[Stemdriller]

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]

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]

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]

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]

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]

Use a textbox and in the control source:

=IIF([HasData], "", "No data available")