Working with two datasets RRS feed

  • Question

  • User-1412642538 posted

    I need to convert an old html report to SSRS and need help.  The current report uses two datasets- one is a parent table that is iterated through to pull a data key; the report then pulls an array based upon the key and displays the associated records.  

    Is there any simple way to do this in SSRS?  Any help is appreciated- I don't have much experience working with more than one dataset.

    Friday, December 17, 2010 11:24 AM


  • User1471008070 posted


    Based on your scenario, I think subreport is a good choice for you, you should pass the parameter to the subreport based on the key value, then display the relevant records. Main report and subreport could have a seperate datasets. Besides, subreport has a better performance.

    For more  about Hot to add a subreport and parameters in Reporting services. Please see: http://msdn.microsoft.com/en-us/library/ms160348.aspx 

    Challen Fu

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, December 20, 2010 4:19 AM