Suppressing a Sub-report

[rainbowrabbit]

Hi,

I am relatively new to Crystal and I have a problem trying to suppress a subreport.

The subreport is sat in the detail section of my report. I can suppress the report if they are no records in the sub-report but a gap still remains in the main report.
I would like to be able to suppress the section in the main report based on the count of records in the subreport i.e. if the is only 1 record I want to suppress the section on the main report.

I have tried variables but because the subreport gets processed nearly last i can't suppress a section on the main report based on a count in it.

Any ideas?

 

[lyanch]

This is very version dependant. You can only suppress the section in version 9 or later. Prior versions you can only make the section small..

Lisa

 

[RJFost]

Au contraire- I use CR 8 & suppress sections and/or subreports all the time.

The easiest way is to open the Report Options for the subreport & check "Suppress printing if no records"- no records, no subreport. Then, in the main report, open the Section Expert, select the section containing the subreport & check "Suppress blank section"- no subreport, no section.

That should do the trick. You can get fancier with running totals, passed values, etc. but this is the simple, brute-force-&-ignorance approach.

 

[lyanch]

RJFost, I don't believe that works.. at least to completely suppress the section.

Here is a link at the support site that tells how to do this 8.5 and prior.

http://support.businessobjects.com/library/kbase/articles/c2005853.asp

Lisa

 

[RJFost]

It works here- maybe a config issue or the like, I don't know...but it's in probably 1/3 of the reports I've done here. Many are used in external reports or loaded to the hospital intranet, so suppressing (fields, sections, objects, subreports, whatever) is a big deal.

 

[lyanch]

I want your version.. its a miracle

 

[rainbowrabbit]

Thanks very much for your help, the both of you!!