Skip to Content
0
Former Member
Apr 23, 2014 at 05:26 PM

How to Suppress the Group when Sub-report is blank

1161 Views

All,

I need help with a problem i have with Crystal Report (2008 version). I have a main report with one sub-report.

Here are the details of Main report:

- Report Header (i have bunch of fields here)

- Page Header (Suppressed using Section Expert)

- Page Header A (Suppressed using Section Expert)

- Page Header B (Suppressed using Section Expert)

- Group Hearer 1 (Suppress Blank Selection using Section Expert)

- Group Header 2

- Group Header 2A (Suppress Blank Selection and Underlay Following Sections using Section Expert)

- Group Header 2B (Suppress Blank Selection using Section Expert)

- Details (Suppressed using Section Expert)

- Group Footer 2 (Suppressed using Section Expert)

- Group Footer (Suppressed using Section Expert)

I have added following to the Main report:

- Column Labels are in GH1

- Sub-report is in GH2A

- 4 Fields are in GH2B

The sub-report is the last column (i.e., right most column) in the report; the sub-report may or may not return a value. If the sub-report does not return a value, i want the report to suppress all columns in the report.

In my sub-report i have two columns/fields, i have all Sections except Details suppressed; the Details section is set to "Suppress Blank Selection".

When i run the report, it will blind/suppress the sub-report column/cell if there is no data for the sub-report. However, it will still show the 4 four columns. How do i solve this issue. Thanks

- Naveen