suppression formulas

[catchingup]

using cr11 to list out clients in hierarchical order.
have 4 groupings:

GROUP HDR1: Unit
GROUP HDR2: Pres
GROUP HDR3: VP
GROUP HDR4: Client
nothing in detail level b/c info only prints correctly when items in this format.

Only want to list clients from a certain time period which i have built into the suppression formula in group4.
What i'm having problems with are groups 2 and 3
I only want group 3 to be suppressed if ALL Items in group 4 meet the conditions of group4 suppression. (and only want to suppress group2 if everything in 3 and 4 meets the criteria)
However if i use the same suppression formula from group4 - it suppresses even if only 1 of the items meets the conditions.

Any ideas?
Thanks!!

 

[synapsevampire]

This:

"Only want to list clients from a certain time period which i have built into the suppression formula in group4"

should probably be done in the record selection formula, and is generally easy to do.

Rather than a vague description of you wanting to suppress certain time periods, why not explicitly state what time periods, show the formula you used, and be open to other architectural ideas?

And again, stating:

"nothing in detail level b/c info only prints correctly when items in this format."

Doesn't describe what is happening incorrectly within, whether you get repeatedly results, bad data, or???

State specifically what is happening, or if you don't know, show what you get and what you want.

For best results post technical info:

Crystal version (did this)
Database/connectivity used
Example data
Expected output

As far as condtional suppression, again it's a bad idea, but you may be able to use:

Finally you state:

"I only want group 3 to be suppressed if ALL Items in group 4 meet the conditions of group4 suppression."

Since you didn't take the time o sshow what the conditions (formula) used to suppress are, how can you expect us to knowand help?.

Consider posting to be akin to providing a mini spec, you need to show specifics.

You might be able to use a summary operation for this, but I think you can do away with all of the suppression by taking a differnet approach, but I'm guessing here, which is all your post allowed for.

-k

 

[catchingup]

in answer to your questions....i'm unable to put items in the details section because the data in a subreport (also in group4) was printing inaccurately.

Formulas and such are as follows - and yes, i also did try putting my dates in the selection formula and that was returning inaccurate info.

RECORD SELECTION - parameter alowing user to select one of 4 units to run report for --- if {?Unit} = "A" then {UnitName} = "ASeries"

GROUP1 - grouped by UNITNAME and prints Unit based upon info selected by user in parameter. Only other info printing are the column headers.

GROUP2 - grouped by PRES.NAME
--only field present in this group is formula for displaying the Presidents name:
@PresName = If Not IsNull({PRES.NAME}) then "PRES: " + {PRES.NAME} else "NO PRES Listed"

GROUP3 - grouped by VP.NAME
--only field present in this group is formula for displaying the VP name:
@VPName = If Not IsNull({VP.NAME}) then "VP: " + {Vp.NAME} else "NO VP Listed"

GROUP4 - grouped by CLIENT.NAME
--several fields at this level inc. Client Name, Number, dates of service, and a Subreport summarizing details of service.

These fields are all just the straight fields - no formulas. There is a formula in the Select Expert:
{@ServiceDate} > DateAdd("m", 3, CurrentDate) or {@Service Date} < Date (2005, 01, 01)

**also in Group4 is a subreport


Detail level - blank

What is happening now, when any item in group 4 falls out of that range identified, the VP and Pres names from groups 3 and 3 disappear.

Please let me know if you need more info.

 

[synapsevampire]

You probably won't be able to suppress at the group headers of the outer groups as they are evaluated before your subreport.

I appreciate the additional effot, but did you really think that "printing inaccurately" described something useful? Again, a subreport is a bad idea at the group level, it issues a query for every iteration of the group.

We don't know what's in {@ServiceDate}, so the following isn't clear either:

{@ServiceDate} > DateAdd("m", 3, CurrentDate) or {@Service Date} < Date (2005, 01, 01)

And if it's in the record selection, then it isn't a suppression, it's filtering the data.

Anyway, I'll leave this to those who want to guess and have ample time to try to get you to post technical information.

-k

 

[lbass]

If you are using suppression formulas, what are they for each group section?

-LB