Can't Hide Rows in SSRS

Question

Have code to show or hide rows based on a value in one of the cells for that row (In SQL Reporting Services)

I either get all the results hidden or none of the results hidden

Tried this

=IIF(Fields!CommodityCode.Value = "BOP",False,True)

Field Name is correct and BOP is a valid value for the field

=IIF(Fields!CommodityCode.Value = "BOP",False,True)

When the value BOP is in the cell then that row should show. Any other rows where the value of that cell is NOT BOP should be hidden.

Answer 1

So the issue here is that your conditional is checking the entire dataset for BOP and not the specific cell. You'll want to modify your expression to the following.

=IIF(ReportItems!CommodityCode.Value = "BOP",False,True)

The ReportItems! should be followed by the name of the textbox that contains the CommodityCode field. So you'll basically only need to replace the CommodityCode with the textbox name. The .Value should stay there.

EDIT: Based on the comment below, it seems you simply need to add a parent group to your data that groups by CommodityCode. In the Row Groups, right click on the details group and click Add a parent group. Then, simply select the CommodityCode field as shown below.

After that, you usually need to remove sorting from the group properties because it adds a sorting field by default. I typically will add a page break between groups, as well.