Hiding a row based on other rows of data.

[cwillard]

I have a report that shows rows of data with columns for year, county, age group, gender, and count.  The options under gender are male, female and total.  The report is in a list and groups by year, county and age group.  I am using a conditional block to hide the count field if it is less than a set number.  I can do this easily for each row but now I need to hide the rows with Total in the gender when the row for Male or Female for the same year, county and age group is less than the set number.

The report is currently built with one set of queries to calculate the male and female counts and a separate query to calculate the total row.  They are then brought together using a Union query. It was done this way because the final query results are based on other queries and calculations that use a waiting which is different for male, female and totals.

Any suggestions on how I could accomplish this would be greatly appreciated.

[Lynn]

Can you create a calculation with a specific scope set using the "for" clause to get the comparison number you need? Can you identify the total row based on some attribute in the result set? If so you can then create an advanced conditional style to hide the total row based on the calculated figure compared to the set figure.

I think advanced conditional styling is way easier than conditional blocks, so might be worth exploring if you haven't worked with them.