Wednesday, March 28, 2012

Question about reporting services

Is it possible to achieve the following:

First OLAP dataset with two report parameters, first one single- select parameters and second one is multi-select parameters. Second OLAP dataset I want to apply the first single-select parameter and the second multi-select parameters from the first OLAP dataset with an additional parameter from one of the column of the first OLAP dataset. If so, how to do it? e.g. the first OLAP dataset returns the id column with the selected first and second report parameters and I want to apply the same report parameters and the id column to filter out the second OLAP cube.

The first and second dataset are from different OLAP cubes.

You cannot apply parameters from one report to another, by the sounds of it your only solution here is to build your second report as a subreport and pass through the params.

No comments:

Post a Comment