Group Selection Formula Help

[Hawk45]

I have a report with 9 groups that show a organizational workflow hierarchy. For example, shows president and everyone under him, then Directors and everyone under them.....all the way to the person who first submitted the idea.

My question is that sometimes ideas come from interns, which goes cascades all the way down the organizational workflow model. But sometimes the ideas come from the Directors(who are much higher up the workflow model) and I have six empty groups below, leaving a large amount of space before the detail information. I want to create a group selection formula (or something) that will hide the empty groups so that I don't have these large gaps. I would also like the grouptree to stop at the last person (the idea submitter). If anyone could give me the best way to do this I would appreciate it.

Thanks,

John

 

[mbarron]

Conditionally suppress each group header using:
isnull(GroupName (the.group))

If that doesn't work try:
GroupName ({@SPU}) = ""

Mike

 

[Hawk45]

mbarron,

I was wondering what ({@SPU}) stands for or referring to?

 

[mbarron]

Sorry. that was my test group name. I forgot to change it when I pasted the second time. Mike

 

[Hawk45]

Forgive me, but I am a novice at CR.

I have tried putting this in in different places and not getting results......where exactly should I put either of the formulas you provided me with??? How do I get a formula as a Group Field?

Thanks,

John

 

[mbarron]

Go to Format, Section...

Pick th Group you want to suppress, click on the (x-2) button next to Suppress.

Find the Group Name in the Report Fields pane (usually on the left) Double click on the Group Name you are setting up to be suppressed. This will place the GroupName (the.group)) in your formula area.

Add the IsNull() or the ="" to the formula. Mike