Why This Suppress Formula don't work?

[deangelis]

Hi, This is the problem:
I have to suppress three subreport if no record is reported.
'Cause I'm not able to do this, I think to suppress all the field in the subreport.
The problem is that the report header is always suppressed or never, why? Thi sis the code:
In the suppress formula:
isnull({Traj_Scenario.scenario_id}).
In the report header there are text field, while in the detail section there is the database field(the parameter inthe formula). The first don't work the last yes!!!!!
Bye
N@pol€on

 

[synapsevampire]

Here's the CD whitepaper on suppressing blank subreports:

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

-k

 

[deangelis]

Thank for the tip, it works.
But I used to want to understand the problem.
Sorry, but isnull({field...}) or count({field...})=0 is the same thing, or no?
If yes, why the first don't work?
ANother thing, perhaps I should ask this to CR team, but however: Don't exist a method to suppress a subreport without suppress all its section?
Bye
N@pol€on

 

[synapsevampire]

Suppressing blank subreports is a new feature of CR 9.

A count() = 0 is not the same as isnull(), and if you don't return any rows, count() = 0 will return null.

-k

 

[dgillz]

For the most part:

Count() is a summary operation and will return either a grant total count (as in your example) or a subtotal count.

IsNull() is a test on a single record which will return true or false.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com