SSRS drill through reports based on a condition.

Scenario: I had a report showing the name of the departments. However, there was a row which contained the text "Other" instead of department name and one row which contained the text "Firm-Wide". The requirement was to navigate to one report based on department name and other report based on text "Other". If the text was "Firm-Wide" no drill through action had to be performed.

Solution: The solution is to specify the drill through reports using IIF condition as shown in the screenshot:

=IIF(Fields!DeptName.Value="Firm-Wide", Nothing,
IIF(Fields!DeptName.Value="Other",
"TimekeeperTitlesMainCapacityReport",
"PracticeGroupMainCapacityReport"))


profile for Nadeem Yousuf at SharePoint Stack Exchange, Q&A for SharePoint enthusiasts

+