Suppress Group Issue

[runningphan]

Hi there...got a bit of a suppression problem.

I have a count that is essentially counting detail records and I have two groups. A user is providing a value that is compared to the count for suppression purposes and then this formula is used within the suppression of the a group header. The problem is that the suppression condition is always true for the first group due to the fact that the detail hasn't been evaluated yet.

Is there a way around this?

The formula being used for suppressing GH1 is:

{#Count of Details} < {User Parameter})

Therefore the GH1 is always supressed since the details haven't been evaluated...

Hope this makes sense.

 

[synapsevampire]

You're using a Running Total, which isn't evaluated until after the details.

You don't state what the formula is doing so we can't really help, please take the time to post technical information in your posts.

If all it is doing is counting the detail records, then try:

count({table.field}, {table.group}) < {?User Parameter}

If it is doing more than "essentially counting the rows", we need to know what it is doing.

In some cases people will create a detail formula of:

//@MyCountFormula
if {table.field} = "blah" then
1
else
0

Then go to the Report->Selection Formula->Group and use:

sum({@MyCountFormula},{table.group}) >= {?User Parameter}

Or you can reference it in suppression formulas using < than for the sections...

-k