Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Tart_SQL
Starting Member
41 Posts |
 Posted - 2008-09-25 : 23:53:49
|
| Is it possible to set a condition enabling a drill through to another report based on values? For example if a value is zero on a column disable drill through option otherwise enable drill through. Will appreciate your help. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-26 : 01:56:26
|
Yup its possible. Right click on cell and select properties. go to navigation tab. in jump to report section give the below expression=IIF(Fields!YourColumn.value=0,Nothing,"DrilldownReportNameHere" |
 |
|
|
|
|
|
Enabling drill through reports