Remove (not hide) group based on Report parameter

cmrdjr

I will preface this with my users never want anything simple.

I have a report where in some instances the user wants to group by an account number and other times when they just want the data all summed up. The data set could be the same, but due to the complexity of the output as well as the ongoing testing and changes I really do not want to have multiple output tables.

I can add a group by account to the output, but when I use the visibility feature I still get the groupings, but the other details are still duplicated.


EXAMPLES
desired output with account grouping

ACCOUNT1
detail
detail

ACCOUNT2
detail
detail

ACCOUNT3
detail
detail

output with account grouping hidden


detail
detail


detail
detail


detail
detail

desired output with account grouping removed

detail
detail

mwilliams

Hi cmrdjr,

Try using the parameter in the key expression for your group.

i.e.

if (param["parameter"]){
row["group_row"]
}

Then you can hide the group header and/or footer with the same check.

Hope this helps.