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:
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"))
