cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Crystal Reports - Filtering a page header section when there are no more records

0 Kudos

Hello,

I have a report that shows sales order info. For each sales order, the items are listed below, with a group header (at the sales order level) showing the column headers. Since there can be many items on an order, a single order can take multiple pages. Which means that the column headers need to repeat onto the extra pages. The column headers for the additional pages of the sales order are being handled by a page header section, which doesn't appear on the first page of the sales order, only the additional pages.

This appears to work except for one circumstance. Each sales order also uses a group footer to provide a couple of summary fields. What can happen is that the listing of items concludes on page two, but the group footer has to continue onto page 3. Then page 3 shows the column headers, even though there is no more data for that sales order. How can I refine my suppression formulas to account for this?

Any help is greatly appreciated!

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Alright, I think I have my answer. I'm able to compare the Next([salesordernumber]) to the [salesordernumber] in my page header where I show the column headers. If the next and current sales order number don't match, I can add that to the list of suppression conditions.

Answers (1)

Answers (1)

0 Kudos

Still hoping someone has an answer on this. Seems like it should be fairly basic functionality in Crystal.