Suppress a Section when a subreport is blank or null

[Bitaoo]

Hello,

I have a problem and hope you can help. In "Group Footer" section of my report, I defined just a Subreport.
I want that this section (GF) is suppressed when the subreport is blank or Null. How can I do that?

I appreciate your help in advance,
--Bita

 

[RJFost]

Go to the section format form; click the condition test for "Suppress" & try this:

IsNull(<subreport>)

You may need to specify that the suppress/no suppress test follows the subreport generation (i.e., play around with an EvaluateAfter statement).

 

[Bitaoo]

Is the subreport in IsNull(<subreport>) formula the name
of subreport (test.rpt) or the name of object (subreport1)?

Thanks for your response,
--Bita

 

[RJFost]

You'll want to reference the subreport object. I got to thinking about this...any way you can suppress the subreport, based on some value/flag test or the like? That way, you don't even bother with the subreport (or it's section) if there's no need.

Also, if you're running CR 8.0/8.5 or better, remember that you can set a value in the calling (parent) report from the called (sub) report; that might get you the suppress-or-not test we talked about.

 

[Bitaoo]

Thanks for all your response but I got the answer from
the following Crystal document:

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

I hope it helps the other guys too.

Cheers,
--Bita

 

[RJFost]

Oh, sure- go to the KB. You kids today— when I was your age, we didn't have knowledge bases...we had thousands of notes on cocktail napkins & smeared PostIt notes...

Just kidding; if I helped at all, it was my pleasure