Passing Dataset data to child report from parent in SSRS
Hi , I have report which calls another report. I wanted to send the dataset data to child report; so that I dont need to run the sp again in child report. This is multi column & multi row dataset Is there any way to do this. ThanksSanjay
January 20th, 2012 3:17am

Sanjay, You can do this with the help of Sub Reports Or Drill-Through Reports For more Information on Sub Reports please refer : How to: Add a Subreport and Parameters (Report Builder 3.0 and SSRS) For more information on Drill-Through Report refer : Drillthrough Reports (Report Builder 3.0 and SSRS)Thanks, Sandip Shinde Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
January 20th, 2012 3:35am

Sanjay, You can do this with the help of Sub Reports Or Drill-Through Reports For more Information on Sub Reports please refer : How to: Add a Subreport and Parameters (Report Builder 3.0 and SSRS) For more information on Drill-Through Report refer : Drillthrough Reports (Report Builder 3.0 and SSRS) Thanks, Sandip Shinde Please remember to mark the replies as answers if they help you and unmark them if they provide no help. Hi, I am already using sub reports - what I was asking for is that how can send multi columns, multi row dataset to sub reports. thanks Sanjay
January 20th, 2012 3:55am

If your question is about passing the data between parent and child report,then use the parameters.Create the parameters in the child report and then from the parent report assign the values from tha dataset of the parent report to the parameters in the child report. HTH. -=-=-=-=-=-=-=-=-= Learn, Earn, Enjoy....!Thanks, Satish Bommideni
Free Windows Admin Tool Kit Click here and download it now
January 23rd, 2012 2:30am

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

Other recent topics Other recent topics