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.

 All Forums
 Development Tools
 Reporting Services Development
 Passing parameters from matrix report

Author  Topic 

chakrapu
Starting Member

1 Post

Posted - 2009-04-30 : 10:44:46
Hello

I have matrix report with three rowgroups, two static columns and a details report.Now when click on subtotals in matrix it sholud go to details report. The problem is when i use InScope() method in parameter expression of jump to report,the parameters passed are incorrect to details report.

The three rowgroups are "Year" under this "PlantID" under this "Month" rowgroup. Now thees three values corresponding to subtotal are to be passed to the detalis report.

Please help me out,
thanks in advance,

chakrapu.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-05-07 : 14:25:05
you can write expression in navigation property to send correct field based on value of Inscope() function to distinguish between subtotal and detail.
Go to Top of Page
   

- Advertisement -