Skip to Content
0

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

Mar 20, 2017 at 11:56 AM

30

avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ian Waterman Mar 20, 2017 at 02:27 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded