Mitsules, Mark S. (Newport News)
Mark.Mitsules at ngc.com
Tue Apr 20 11:41:45 CDT 2004
Interesting...works like a charm, but this approach doesn't seem intuitive to me. Is this common practice? Thanks, Mark -----Original Message----- From: Gustav Brock [mailto:gustav at cactus.dk] Sent: Tuesday, April 20, 2004 12:28 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Re: Report Page Header Hi Mark > Is there no way to test for detail records printed on a report page, and, > then based on that, hide the page header? This is not a page header but a group header. Create a dummy group with your labels: Set Field/Expression to =True Set Group Header to Yes. In the report, adjust the group's layout properties: Set Keep Together to False Set Repeat Section to True /gustav > I realize I can add a group header, but can I do so without actually sorting > or grouping? For this report I have the field headers in the page header. > I want to be able to suppress that page header when there are no detail > records to be printed for that page. This is not the same as on no data. > For instance, let's assume a full page of details contains 80 records. The > first page, because of the report header can only accommodate 60 records. > The last page, because of the size of the report footer, can also > accommodate 60 records. If my report only contains 60 records, the report > length will still be 2 pages but no details will be on the second page. > Currently, because I am utilizing the page header to hold the field headers, > the page header will print on the second page. In the above case, how do I > suppress the page header if no detail records are on the page? -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com