[AccessD] Re: Report Page Header

Mitsules, Mark S. (Newport News) Mark.Mitsules at ngc.com
Tue Apr 20 12:23:46 CDT 2004


>>a group control source can consist of a field name, function,
string, etc.  Anything that will evaluate at runtime.<<


This was the part that I was not aware of...thanks.


Mark


-----Original Message-----
From: Brett Barabash [mailto:BBarabash at tappeconstruction.com] 
Sent: Tuesday, April 20, 2004 1:02 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Re: Report Page Header


Don't know if it's common practice, but I commonly use dummy headers in my
reports.  For example, I have a quote that consists of 6 different sections,
which can be selectively hidden by the user from a print dialog.  I name my
report sections with a string literal as the control source:

="Table of Contents"
="Pricing Plan"
="Terms of Payment"
...

Remember that a group control source can consist of a field name, function,
string, etc.  Anything that will evaluate at runtime.  My string literals
will never change throughout the course of printing the report, thus the
section only prints once.


-----Original Message-----
From: Mitsules, Mark S. (Newport News) [mailto:Mark.Mitsules at ngc.com]
Sent: Tuesday, April 20, 2004 11:42 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Re: Report Page Header

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?


----------------------------------------------------------------------------
----------------------------------------
The information in this email may contain confidential information that 
is legally privileged. The information is only for the use of the intended 
recipient(s) named above. If you are not the intended recipient(s), you 
are hereby notified that any disclosure, copying, distribution, or the
taking 
of any action in regard to the content of this email is strictly prohibited.
If 
transmission is incorrect, unclear, or incomplete, please notify the sender 
immediately. The authorized recipient(s) of this information is/are
prohibited 
from disclosing this information to any other party and is/are required to 
destroy the information after its stated need has been fulfilled.

Any views expressed in this message are those of the individual
sender, except where the sender specifies and with authority,
states them to be the views of Tappe Construction Co.

This footer also confirms that this email message has been scanned
for the presence of computer viruses.Scanning of this message and
addition of this footer is performed by SurfControl E-mail Filter software
in conjunction with virus detection software.

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



More information about the AccessD mailing list