[AccessD] Re: Report Page Header

Is there no way to test for detail records printed on a report page, and,
then based on that, hide the page header?



Mark



-----Original Message-----
From: Mitsules, Mark 
Sent: Tuesday, April 20, 2004 8:05 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Re: Report Page Header


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?



Mark


-----Original Message-----
From: Robert L. Stewart [mailto:rl_stewart at highstream.net] 
Sent: Monday, April 19, 2004 5:01 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Re: Report Page Header


In a band report writer, which Access is, the detail header is in the 
grouping header just above it.  You have to make it visible.

There is a event in the report for No data.  You would put code in that 
event to handle what ever you wanted to do there.

Robert

At 03:42 PM 4/19/2004 -0500, you wrote:
>Date: Mon, 19 Apr 2004 16:10:22 -0400
>From: "Mitsules, Mark S. (Newport News)" <Mark.Mitsules at ngc.com>
>Subject: [AccessD] Report Page Header
>To: "'[AccessD]'" <AccessD at DatabaseAdvisors.com>
>Message-ID: <D3E2A213B8F45B4DAC92EB5FD98ED1EF010EBB78 at nnse14.nns.com>
>Content-Type: text/plain
>
>First, a really stupid question...why is it that Access reports do not have
>a "Detail Header" section?  It seems simple and to the point for a lot of
>what I do when grouping is not needed.
>
>
>Second, when printing a report, what is the syntax to check if there are no
>detail records on the page and suppress the Page Header if there are none?
>
>


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com