Determine if there is more than one member in a group
I've got a report with two groups, the first group "department" is used to seperate the details rows based on the only the one field and the group does have a summary row as there may be several departments included in the report. The second group "Region" only has a footer which simply totals all the values for related "department" details. Here lies the problem, I don't want to see the "Region" totals if there was only one deparment in the "department" group because esentially this would be an exact duplicate the "department" summary row and isn't needed. Any suggestions for the expression that would be needed in the "Region" rows Visability property to control whether the row is displayed or not. Thank you, Dan
November 10th, 2010 10:27pm

I use RunningValue()
Free Windows Admin Tool Kit Click here and download it now
November 11th, 2010 3:59pm

Hi Dan, In order to hide the total in the “Region” Group Footer if only one department is included in this region, we can specify the Hidden property of the cell to the expression like: =IIf(CountDistinct(Fields!Department.Value)>1,False,True) Please correct the department field name in the expression based on your report, and in the expression, the CountDistince function will returns a count of all distinct departments in the region. Thanks, Tony ChainPlease remember to mark the replies as answers if they help and unmark them if they provide no help
November 15th, 2010 12:51am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics