Groups Hide
Posted: Fri May 05, 2023 6:10 pm
I have a report with 3 groups. I want the groups to print/show only when certains values exist.
I want group 1 to always print.
I have data column called Type.
I want group 2 to print if value of Type is not x,y, or z. (this will print formatted data for those Types not in x, y or z.)
I want group 3 to print if the value of Type = x,y, or z. ( this will print differently formatted data for those Types = x,y or z)
The goal is the different formats and order that the groups are printed.
I have tried IIF as group expression without success. I do not see a place/property or way to add a condition.
I hope that makes sense. Any suggestions?
John W
I want group 1 to always print.
I have data column called Type.
I want group 2 to print if value of Type is not x,y, or z. (this will print formatted data for those Types not in x, y or z.)
I want group 3 to print if the value of Type = x,y, or z. ( this will print differently formatted data for those Types = x,y or z)
The goal is the different formats and order that the groups are printed.
I have tried IIF as group expression without success. I do not see a place/property or way to add a condition.
I hope that makes sense. Any suggestions?
John W