Creating Reports on the Fly

[eacham]

I have a report that contains 7 subreports. Each report contains data from different tests run through out the day. Some days the tests are all run, other days only a couple are run. You never know what tests are going to be run for that day. I want a report to print out all the information for the test(s) ran that day. The way I have it set up right now is with subreports. If there is no data for that day it will leave a blank area on the report. I was wondering if there is any way I can create the report on the fly each day for the data of the tests that were ran.

 

[Rich]

If you set all the subreports can shrink/grow to yes they should disappear when empty.
HTH

 

[DES]

You have the right idea the way you have it. The trick is to set each sub reports Can Shrink and Can Grow to true.

Go into design view of the master report and click on one of the sub reports. Go to its properties here and you will see these options on the format tab. Do not open the subreports!

 

[eacham]

Thank you!!!