Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Crystal Reports IX: How to suppress printing a Group Header when the details start on the next page?

I've got a report with a large group-header, and want to suppress it if the details don't start until the next page, where the group header is repeated. Any ideas?

Update:

Forcing a page-break is not an acceptable option, as there are some sections that will print with a single detail record, thus wasting large amounts of paper.

The group-header is repeated on the next page with the Repeat Group Header on Each Page checkbox. I've figured the solution out, but thanks for asking. Hopefuly, you learned something.

3 Answers

Relevance
  • Jeff B
    Lv 5
    1 decade ago
    Favorite Answer

    Hi. How did you configure your Group Header to cause it to be repeated? Are you sure that it's not the Page Header that's being displayed on the next page?

    One option you have is to enable the New Page Before option on your group header. This ensures that the group header begins at the top of a page thus leaving the maximum amount of space possible below the header for the details to be printed.

    Response to author's Additional Details:

    If you don't mind, can you share how you solved the original issue?

    Also, for those reading this Q&A, the Repeat Group Header on Each Page option isn't located in the Section Expert. You need to use the Change Group feature and then go to the Options tab to enable the Repeat Group Header on Each Page.

    Since there are only 2 hours left before this question is closed I thought I'd post some additional information that might be helpful to the viewing audience. I don't know how the author opted to solve the problem but I did come up with a viable solution (albeit a somewhat ugly one) using Global Variables.

    Create the following 2 formulas:

    @Group Header Print Count Reset

    // Group Header Print Count Initialization

    WhilePrintingRecords;

    Global NumberVar GroupHeaderPrintCount;

    GroupHeaderPrintCount = 0

    @Group Header Print Count Increment

    // Group Header Print Count Increment

    WhilePrintingRecords;

    Global NumberVar GroupHeaderPrintCount;

    GroupHeaderPrintCount = GroupHeaderPrintCount + 1

    Add the formula @Group Header Print Count Reset to the Report Header. Also add it to the Group Footer. Add the formula @Group Header Print Count Increment to the Group Header.

    Then, assign to the Group Header's suppression formula the following:

    // Group Header Suppress

    WhilePrintingRecords;

    Global NumberVar GroupHeaderPrintCount;

    if (GroupHeaderPrintCount > 0) then

    true

    else

    false

    I haven't tested this (ran out of time) but it should work. Hope it's helpful.

    Jeff

  • ?
    Lv 4
    5 years ago

    Crystal Reports Page Break

  • ?
    Lv 4
    5 years ago

    lets be happy that this Democrat has some recognize for the structure. allow's desire that contained in the destiny wiser heads will prevail in the previous such unAmerican events will be allowed. in the interim i'm nevertheless waiting to hearken to this record has been retracted. I save listening to it truly is been refuted, yet i need it withdrawn.

Still have questions? Get your answers by asking now.