If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional Header
I'm trying to generate a reports from a database in which one of the =
fields=20 describes the importance of each record for example the field values = would=20 be: Routine, Priority, Urgent The report needs to contain the highest priority in the header. In = other=20 words the report may contain several records on a single page, but the=20 header needs to have the highest priority label regardless of how many=20 different priority records are on that page of the report. It's easy = enough to=20 do if there is only one record per page, but I can't figure out how to = label=20 the page with the highest priority when there are multiple records per = page. Any suggestions? Thanks for your help. |
#2
|
|||
|
|||
Conditional Header
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 "Lee" wrote in message ... 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. |
#3
|
|||
|
|||
Conditional Header
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=20 within the page there is data of an urgent nature. Thanks, Lee -----Original Message----- 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 "Lee" wrote in message ... 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=20 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=20 page. Any suggestions? Thanks for your help. . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Header formatting in LINKed docs not working | Dennis | Page Layout | 4 | July 5th, 2004 10:04 AM |
Header Height won't adjust | Mary | Page Layout | 2 | May 24th, 2004 11:18 PM |
Headers and Footers | Specter7 | New Users | 2 | May 17th, 2004 03:51 PM |
Gigantic Header | Greg | Page Layout | 1 | May 7th, 2004 10:08 PM |