I created a report that groups on week ending dates and has a total for each date and a grand total for the month. However, The report is 13 pages long with many blank pages since I said no to visible detail. How do I change the report to print everything on one page. It should fit but the hidden detail is forcing multiple pages.

Thanks in advance,

Derek

You can set the CAN SHRINK property of the detail section to YES. That way, if there is any invisible item, the detail section will shrink.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division