Search code examples
ssrs-2008

Specify drill down report based on condition

I am specifying following IIF condition in Textbox action property to run a drill through report:

=IIF(Fields!DeptName.Value="Department Total", Nothing, "TimekeeperTitlesMainBECReport")

When DeptName is not "Department Total" the texbox is properly clickable. However, it is clickable even when DeptName is "Department Total". I understand that both sides of IIF are executed. However, I am not able to figure out how to fix this issue.

Solution

  • Do you specifically mean that you have enabled Action -> Go to report on the textbox (i.e. a drillthrough report)? This is not the same as a subreport.

    As you've described it, it should be working as you expect. I cannot replicate your issue in Visual Studio - with a similar expression I get no option to drillthrough where the expression is evaluating to Nothing.

    I would start by recreating the textbox/action and see if this resolves the issue.