Suppress Report Footer based on Subreport record count

building reports crystal reports
1

Hi,

I have 3 subreports placed in 3 Report Footer sections namely RHa, RHb, RHc. Based on a input parameter the subreports need to be shown or suppressed. Input Parameters are like this

SubReport1
SubReport2
SubReport3
All Subreports

If ‘All Subreports’ option is selected, we need to display all the subreports
which has atleast 1 record. So, I have enabled “Suppress Blank Subreport” in “Format Subreport” menu and “Suppress Blank Section” in “Section Expert” for the corresponding report section.

This works as expected. But, we need to have a page break between every subreport. To achieve this, I have enabled “New Page After” in “Section Expert” for RHa and RHb.

If Subreport3 has no records, there is a blank page appended because of the “New Page After” option.

Can I conditionally enable “New Page After” on RHa based on “Suppress Blank Section” on RHb?

Thanks,
Crysguy

crysguy (BOB member since 2008-05-13)