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-07 : 10:23:57
|
HiI have a report using matrix data object, now my users would like to be able to click on any number on the totals and be able to drill through to the underlying data. e.g The report is about departmental heacount based on staff type. on the rows I display the department and the column heading is staff type (Contract, Perm, etc). I have created another report which I use as a sub report for this exercise and it work fine if you click on a particular staff type but not when you select the total. Is there a way I could be able to do it with the totals column. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-13 : 11:07:54
|
| yup you can. what are parameters you pass while navigating from main report?for total, you dont need to pass any value for stafftype. |
 |
|
|
|
|
|
Drill Through