Joan Ferrer on Wed, 17 Apr 2013 17:11:33

Hi everyone,

there is something I don't know how to do it. I have a dataset that provides data to a report and some controls.

I have another report with a map. I would like to take the data of the previous dataset that the user has selected (year, region, ...). I would like to take some of this data as parameter to run a stored procedure that is going to provide me polygons to populate the map.

Any idea how to get it?





Mike Yin on Fri, 19 Apr 2013 08:03:43

Hi Joan,

To achieve your goal, you can use the Drillthrough report. In Reporting Services, a drillthrough report is a report that a user opens by clicking a link within another report. Typically, we also pass parameters from the previous report to the drillthrough report.



Joan Ferrer on Fri, 17 May 2013 14:54:05

Thank you very much Mike. The customer didn't like the idea of using a drillthrough report and I have not tried to do it. The customer proposed to call directly the cube. Thank you very much anyway.