Report Portal

Passing MDX parameters in Reporting Services reports

A common requirement in reporting applications is to drill down from parent report into details about selected part of the report. Reporting Services provides a handful of such navigation options, more specifically jump to report, jump to bookmark and jump to url. In my example I use jump to report option and from parent report (Top 10 products) I can drill down to sales details of selected product. Now, with relational data source I'd probably fetch ProductID and ProductName and I'd pass them to detail report as parameters. But how to do the same thing with MDX datasets?


Tags: mdx, ssrs


2007-2015 VidasSoft Systems Inc.