Selecting or Suppressing certain rows/groups 1

[bnsSteve]

Hi there,

I'm wondering if there's a way to suppress or hide a group but only on certain conditions?

Ex:
GH1 - [Issuer Bob]
GH2 - [Client] [count of cert#]
D - [Issuer] [Cert#] [Acct#] [Boolean for type of cert] [Client#] [lastname client] [first name client]
GH2 - [Client] [count of cert#]
D - [Issuer] [Cert#] [Acct#] [Boolean for type of cert] [Client#] [lastname client] [first name client]
D - [Issuer] [Cert#] [Acct#] [Boolean for type of cert] [Client#] [lastname client] [first name client]
GH1 - [Issuer John]
GH2 - [Client] [count of cert#]
D - [Issuer] [Cert#] [Acct#] [Boolean for type of cert] [Client#] [lastname client] [first name client]

What I would like to do, is under each GH1(issuers) suppress any GH2(clients) where the count of the cert# is greater than 1 (has more than one detail row). So in this case, GH1 John has a GH2 that has two cert# (shows two detail rows), I would like it to show that Client but suppress or hide the other Client row with only 1 detail row and do this for each GH1.

I hope this is possible, if there are any other ways I should be approaching it all ideas are welcome.

Please let me know if I need more explanation.

Thanks!
bnssteve.

 

[MCuthill]

bnssteve,

I mocked up a similar report using my database.

Under the "Section Expert" > "Suppress" > "X+2", enter the following for all sections you would like suppressed. (in your case GH2 & Details I beleive).

{SuppressionFormula}

Count({Certificate Number}, {Client})>1

I beleive this to be what you are seeking, please advise should I have misunderstood.

Cheers!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."

 

[MCuthill]

bnssteve,

Despite it being my first language, I am poor at English structure sometimes.

For each section you wish to suppress, navigate to the suppression formula in the section expert (Section Expert > Suppress (No Drill-Down) > X+2). The formula will need keyed in once for each section, not keyed in one place and the sections somehow set via the formula.

Cheers!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."

 

[bnsSteve]

Hi Mike,

Thank you for the quick response, much appreciated.

I tried entering in the formula under the section expert>suppress>x+2 but I appear to be getting an error that reads "A group condition is not allowed here" and highlights the {Client} part of the formula.

For the second part of your reply, not quite sure what you mean by entering the formula in for each section? I only need to suppress the GH2(client) section and no other groups, does this still apply? Not sure how I would apply the formula in "each" section?

Thanks Mike!

 

[MCuthill]

bnsSteve,

I stated for each section, as I *think* you need to suppress the details as well (unless handled automatically by the group suppression... I can't recall). We will get the formula working for GH2 and go from there, it may not be needed.

The syntax of the formula above is COUNT({Field},{Group}), what field is used to define Group #2? It is this field you need in place of "{Group}" (as your field for Certificate Number would be in place of "{Field}").

Hope this helps! Please advise should you still receive an error or have any further questions.

Thanks!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."

 

[bnsSteve]

My mistake! Added in an extra {group}.

OK now that's taken care of (worked great!), how would I suppress the details that were under the Clients that are suppressed, while keeping the details for the Clients that remain?

After the Clients in GH2 with a cert count of 1 are suppressed, the details remain so they are being clumped together with the Clients that didn't get suppressed. Didn't see that one coming...

Hope this makes sense, thanks again Mike for the help.

 

[bnsSteve]

Wait I think I get what you were saying before about applying it to each section...haha.

Just applied it to each group that i didn't want to see, works great.

Thanks Mike!