How can I make my Drill Through links available only to specific values in the list column

Answer

This can be achieved by using a conditional block inside the list with a defined variable.


    

Step by step instruction     
    

       
1. Add a list container to your report
       
2. Add your Data Item that you want to set the Drill Through Definition on
       
3. Add the same Data Item a 2nd time
       
4. From the Toolbox Panel -> Advanced add a Conditional block to the list.
   You should now have a list with 3 columns
       
5. Now define your Drill Through Definition on one of the Data item colums.
   The other Data Item column stays the same.
       
6. Open the Queries Pane and change to the Expression Explorer to create a new variable
       
7. Add a new Boolean Variable using an expression like: IF ([DATA ITEM] in ('VALUE','VALUE')) THEN (1) ELSE(0)
       
8. Unlock the report
       
9. Go back to your list and select the Conditional Block
       
10. Open the Properties and set for the Block Variable the Boolean Variable from Step 7
       
11. The Property Current Block is set to NO. So drag the Data Item without the Drill Through Definition into the Conditional Block
       
12. Change Current Block to YES and this time drag the Data Item with the Drill Through Definition into the Conditional Block.
       
13. Delete the now empty Columns
           

You can find attached a sample report specification to show the result of the steps above.