Crystal reports suppressed section still leaves blank spot

7
votes

I have a Section that only contains a SubReport.

I have a formula on "suppress (no drill down)" that hides the subreport. This works. However it leaves a big blank white space where the subreport would have been if it was visible.

I have ticked "Suppress Blank Section" and unticked "Keep Together" on the surrounding sections without any effect. How do I change it so my hidden/suppressed section does not display any empty white-space?

I am using Crystal Reports 11.

UPDATE It may not be the blank sections causing the issue, could it be the 2nd sub report which I do want to show is 2 big to fit on the first page so just starts on the 2nd page. I have unticked "New Page Before" and "Keep Togeather" for it

4
crystal-reports
Do you have "Suppress Blank Section" checked on your SubReport as well? – JustinStolle
Yes - but there is actually data for the sub report, but I just want to hide it based on a parameter – Daveo

4 Answers

4
votes

OK, I sorted it out.

The problem was the next subreport / section I wanted to show was too long to fit on the first page so was starting on a new page each time.

To fix I had to right click the subreport click "format subreport" then click the subreport tab, then untick "Keep Object Togeather"

0
votes

You will have suppress blank section in the sub report as well. Try checking this suppress blank section in all the sections of the subreport. It should work for you

0
votes

Use same or similar formula (which you use for subreport hiding) for main report section supressing too. "Supress blank section" doesn't work well with subreports.

0
votes

Right click on the subreport. Format Subreport -> Subreport -> Suppress Blank Subreport.

This option is available at least on version 11.5.x