Suppress Grouping not working like expected 1

[cyreports]

In my report, I am grouping 4 levels.

Group 1 - {Data. ApptStart}
Group 2 - {Data.Facility}
Group 3 - {Data.Resource}
Group 4 - {Data.FinancialClass}

On my Group 3 Header and Footer, I have on the 'Suppress (No Drill-Down)' (under the 'X-2') the following statement:

{?FACGROUP} = TRUE

{?FACGROUP} is set up as a boolean and when my end user selects this option I want to completely suppress the Group 3, although whats happening is its still grouping as if the Grouping is still there. Not sure how to set this up and make this work right. Any insight is appreciated.

 

[briangriffin]

The grouping still occurs whether or not you suppress the group header and footer - it sounds like you want group 3 to be financial class if the user responds true to the parameter - right?

Try this - create a formula called Group3Value:

if {?FACGROUP} = true then {Data.FinancialClass} else {Data.Resource}

Then change group 3 to group on the formula, not the resource field.

In your case I don't think you'll have to do anything with group 4 - since groups 3 and 4 will be the same (if the user answers true) there won't be any change in way the data is grouped, and your current suppression formulas will hide the header/footer.

 

[lbass]

Group on this formula for your group #3:

if {?FACGROUP} = true then
"" else
{Data.Resource}

...assuming data.resource is your group#3 field. Then your group #4 won't be affected. You should then format the group #3 sections to "suppress blank sections".

-LB

 

[cyreports]

Worked like a charm!