dpeterson
Posts: 13
|
| Posted: 10/12/2007, 11:11 AM |
|
I am trying to generate a Report and I've run into a problem. Allow me to descibe the problem in a bit of detail. The Report is meant to display an order, and it has two groups. The first is by the Order Number and the second is by the Vendor. We then display the rest of the detail (like Item, Quantity, so forth).
Now the problem we are encountering has to do with Page Headers and Footers. We want the Report Information and the Vendor Information to repeat on every page.
The first idea was to put into the Vendor Header a page break along with a page break in the Page Footer section. This will display the Vendor Headers on a new page when get a new Vendor. The problem with this is that the page footer doesn't report the correct page, since it calculates the page number by dividing the total number of records by the records per page. It also adds an empty page (because of the first Vendor). If I add it to the Vendor Footer, however, we get extra blank pages (either the last Vendor or when a page ends on the end of the Vendor, you get double page breaks).
You can't remove the page break in the Page footer section because otherwise there is no footer for the case when a Vendor's list is more than a page.
I guess my problem is this:
Is there a way to dynamically determine when to display a header/footer or not? If there is, I could always put the header information on the Page Header page, but will that detect the case where I want to break the page because of the end of Vendor (the only way I can see this being done is by putting a page-break in the Vendor Footer, but then I get to the problem above).
So perhaps there is a way to hide the Page Footer when it was the Vendor that created a page break so I don't get double btreaks? The other question is there a way for the Page Footer to count the pages even when the page can be broken for more than one reason (either the Vendor ending, or too many lines on a page).
I am not sure if I expressed the problem clearly enough or if I am just too confusion.
Thanks for your help
--Dan
|
 |
 |
|
