Crystal Reports 8.0 -- suppressing blank subreports

anazoal

Senior member
May 30, 2000
421
0
0
Does anybody use Crystal Reports?

I have a main reoprt with 12 subreports, most of the time several of these subreports are blank. How do I get rid of the "white space" on the main report?

The knowledgebase says this. How do I use the formula not isnull ({table.field})? Which field do I use, and do I add the formula at the begining as a statement, or join it to the existing statement? Do I use the parameter field, or all the fields in the subreport?

As you might have guessed I'm new to Crystal Reports and any help would be appreciated!!!!
 

scauffiel

Senior member
Aug 11, 2000
455
0
0
Did you try right-clicking on the section the subreport is in, choosing "format section" then check the box that says "Suppress blank section"?

Steve
 

anazoal

Senior member
May 30, 2000
421
0
0
Thanks scauffiel. That doesn't work though. A subreport is an object in the main CR report, and so suppressing the section like that won't work because the (blank) object is still there -- i.e. the section is NOT considered blank.