I have a report sectioned by Request ID. In the body of the report is a field called Claim System. I want to hide the section if none of the rows in the section is from 1 of 5 specific Claim Systems.
I thought about creating a numeric flag which I would set for each row in the Body to 1 or 0 depending if the Claim System was one I was looking for.
I then thought I would create a variable that sums the flag up and rolls it up at the Body level and then set the Hide Section box using a formula to check whether the variable was = 0, thus hiding the section.
It’s not working.
Anyone have any suggestions on how I should tackle this ?
Thanks.
tscoccol (BOB member since 2003-11-15)