Search code examples
sql-serverreporting-servicesparameterssubreports

passing values into Sub-Reports SSRS


I have a master report that has no parameters. But I have to include a sub-report with the same grouping as the master report. (i.e, the same report has to show data for the same project listed in the master report) I'm using different Datasets for both reports but the tables come from the same database. I've tried including a parameter into the subreport and pass the current projectID into the parameter of the subreport. It doesn't seem to be possible.

Is it possible to pass field values in master report as parameters in subreports?


Solution

  • I'm a bit curious on your "it doesn't seem to be possible" because I'm currently working on master report and subreport as well. The answer for your short question is "YES". it is absolutely possible to pass value from master report to subreport.

    So Can you please check them again whether their properties are correct or not? For example.

    1. Your subreport's parameters are created properly?
    2. You can try put your subreport inside detail row of your master report.
    3. When you set properties of subreport, you can set which field of master report you want to be a parameter for subreport. it's quite straightforward.

    Hope this help.

    PS. sorry for my poor english.