Drill down a column in SSRS Report base on a value

Question

I have reports that have drill downs. Currently, there are some columns with zero values and users are still able to click on that empty or zero cell and access a blank report. We want to take off this ability so that when a cell or column is zero or empty the drill downlink is disabled. How do I accomplish this?

Answer 1

I'm assuming you mean you click on the cell and you have set the action on the cell to open a subreport? If this is correct then set your subreport name (in the action properties) to be an expression such as

=IIF(Fields.MyCell.Value = 0, nothing, "MySubReportName")

When the user clicks the cell nothing will happen.