Reporting Services condition based drill-through reports
July 31, 2007[From MSSQLTips.com]
One great feature of Reporting Services is the ability to drill through to secondary reports. This is pretty straightforward to do, but the built-in option in Reporting Services is an all or nothing approach. Sometimes there is a need to drill through to secondary reports based on certain data conditions, but you do not want a link for every row only certain ones. How can you provide a link for some data records but not others?
The solution is to use if IIF() function within the report navigation expression window.
The article continues at http://www.mssqltips.com/tip.asp?tip1297