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 to an olap dataset

Author  Topic  pmak Starting Member 41 Posts Posted - 2006-08-05 : 12:46:08 I have a matrix report based on an OLAP cube and it can drillthrough passing minimum 3 or maximum 5 parameters, depending on the expanded/collapsed state of the column and row grouping in the report, to a linked report also using the same OLAP cube. My question is how to set the linked report to allow the passing parameters and in some case set up the default values if parameters are not available from the main report. I have tried using the wizard to build the dataset using the OLAP cube and assigning the parameters to it. it complained about the "Strongset" on the MDX query. I set all the report parameters on the linked report as follows: internal - yes multivalue - yes available value - "non query" default vales - "null" or "from query" on two of the report parameters to use all available values with that fields if no passing parameters from the main report. Thanks Paul Mak