3 April, 2012 (10:00) | MDX, SSRS | By: Mark V
I am currently working on a project involving many reports against an Analysis Services 2008 R2 cube that we implemented for the client. The available values lists for the report parameters are largely just lists of members of various dimension attribute hierarchies from the cube. Since we are not going to actually use any measures [...]
Tags: MDX, SSRS, ssrs parameters | 2 comments
5 January, 2010 (13:08) | SQL, SSRS, T-SQL, XML | By: Mark V
SQL Server Reporting Services provides a great way to allows report users to select more than one value from the available values list in parameters, creating a multivalue parameter. SSRS dynamically creates a comma separated list of the values selected by the user to pass in to the data source. Great. It also dynamically creates [...]
Tags: nodes, parameters, scooby doo, SQL, SSRS, ssrs parameters, T-SQL, XML | 7 comments