Trying To Hide a Section, Need Help With Context

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 :us: (BOB member since 2003-11-15)

Try a search on BOB, suggested keywords: rank measure filter

or start here


Andreas :de: (BOB member since 2002-06-20)

I can’t create a rank against my numeric flag because the body of each section can have multiple 1’s or 0’s. – I get the #multivalue# when I try.


tscoccol :us: (BOB member since 2003-11-15)

To hide blocks based on the sort of flag you are talking about I have used MIn() = (whatever the value should be). However, I have not used this on Sections. My experience with sections has been that If it’s possible to have multivalues it doesn’t work very well. :frowning:


G.E.Davies :uk: (BOB member since 2003-01-20)