Skip to Content
avatar image
Former Member

Crystal Report - How to suppress a group header and the sections below that

Hello,

am using Crystal Report 2008 12.3 version. MY Report design is like below

Group Header 1

Group Header 2

Group Header 3

Details Section

In the Group Header 2 & 3 and Details section i need to show up records based on the few conditions. And i gave the condition in Group Header 2 -> Selection Expert -> Suppress (no Drill down) like { table.color <> "Green"} indicating the Group Header should not display the details other than "Green". I pasted the same condition in Group Header 3 and Details section.

But whenever a record with different color other than Green is fetched, it just skips or suppress the Group Header 2 but display Group Header 3 and Details section.

I want to skip or suppress all the sections below the Group Header 2 if the color is not "Green" . How to achieve this?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 20, 2017 at 02:27 PM

    You need to do suppression in Group Filter not section suppression.

    Create a formula

    @Green

    If table.color = "Green" then 1 else 0

    In Group selection place formula

    Maximum(@Green, Group2Field) <> 1

    Ian

    Add comment
    10|10000 characters needed characters exceeded