Conditional Header

  • Thread starter Thread starter Lee
  • Start date Start date
L

Lee

I'm trying to generate a reports from a database in which one of the fields
describes the importance of each record for example the field values would
be:

Routine, Priority, Urgent

The report needs to contain the highest priority in the header. In other
words the report may contain several records on a single page, but the
header needs to have the highest priority label regardless of how many
different priority records are on that page of the report. It's easy enough to
do if there is only one record per page, but I can't figure out how to label
the page with the highest priority when there are multiple records per page.

Any suggestions? Thanks for your help.
 
If your report is sorted and or grouped by this 'importance' then just
include the field in the page header. If I am not mistaken, it will show
the value in that field for the first record on the page.

Rick B


I'm trying to generate a reports from a database in which one of the fields
describes the importance of each record for example the field values would
be:

Routine, Priority, Urgent

The report needs to contain the highest priority in the header. In other
words the report may contain several records on a single page, but the
header needs to have the highest priority label regardless of how many
different priority records are on that page of the report. It's easy enough
to
do if there is only one record per page, but I can't figure out how to label
the page with the highest priority when there are multiple records per page.

Any suggestions? Thanks for your help.
 
Rick

Thanks, but actually there are several reports and not all are sorted by
importance the header is just to make the reader aware that somewhere
within the page there is data of an urgent nature.

Thanks,
Lee
 
Back
Top