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 |
|
Trybbe
Starting Member
27 Posts |
 Posted - 2009-05-19 : 09:07:43
|
| Hi I need help pleaseI would like to create a drill through on my matrix data region. Currently I have managed to drill through on any of the matrix cells but I'm not winning with totals.So I've been searching for solutions and many seem to suggest the use of InScope function. Now I have tried some thing like this=Iif(InScope("matrix1_Total"), count(Fields!HC_CAT1.Value, "matrix1_Total")) but I'm not winning.My matrix is as follows: A B C TotalA 1 2 3 6B 2 3 4 9C 3 4 5 12Total 6 9 12 27I would like to be able to click on any number on the totals and be able to drill through to the sub report.Please help |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-19 : 10:34:23
|
| what all you pass as parameters to subreport? |
 |
|
|
|
|
|
Using InScope Function