Drill Down from OLAP report to OLTP Report Using Parameters ssrs 2005
Hi Experts, I have a Requirement that I want to navigate form Report which is using OLAP and to the report Which is using OLTP database respectively. Now i have parameters in the OLAP Report and that parameter is Multivalued. Is it possible to navigate using this parameter to the OLTP Report?. It Would be Kind if u help me get through.Avenash.M.G
April 28th, 2011 4:58am

I assume that you have two .rdl files, one each for OLAP and OLTP. You can use a text box as a link to navigate (Drill through) from OLAP report to your OLTP report. Select the 'Action' property of the text box and click on 'Go to Report' option, select your OLTP report there. Then you can add the parameters you want to pass to the other report, below that. MSBI Developer
Free Windows Admin Tool Kit Click here and download it now
April 28th, 2011 7:26am

Hi TDPN, here i have a Pie chart and that pie chart is filtered using parameters such as Issue State and when i click the slice in the pie chart(OLAP rdl), i should be able to navigate to the OLTP rdl and its in the Tabular format !!! the issue state filter should be carried through...Avenash.M.G
April 28th, 2011 7:55am

hi, I found the Solution thanks for the replies :)Avenash.M.G
Free Windows Admin Tool Kit Click here and download it now
April 28th, 2011 9:47am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics