Skip to Content

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


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!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Posted on Jun 06, 2019 at 01:40 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 06, 2019 at 01:06 PM

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

    Add comment
    10|10000 characters needed characters exceeded