SSRS Sub reports and passing parameter values
I have created a main SSRS report that accepts one paramter (item).
I created a sub report that accepts one paramter (also item). When i link the reports on item I can only use first function, to link the reports. That only brings back the first item in the second report. I need to see all the item associated with the first report in the second report not just the first item. Does anyone know how i can accomplish this?
I created a sub report that accepts one paramter (also item). When i link the reports on item I can only use first function, to link the reports. That only brings back the first item in the second report. I need to see all the item associated with the first report in the second report not just the first item. Does anyone know how i can accomplish this?
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
How did you implement the parameter usage in the subreport? Does the subreport work when you run it separately (by typing a valid value for the item parameter manually)?
In SSRS the Sub-report is just a standalone report just like your main report.
The sub-report has to have it's own Query or stored procedure and be able to run and produce the results you what. Once that is done then bring it into the main report and pass what where parameters you need from main to the sub-report.
The sub-report has to have it's own Query or stored procedure and be able to run and produce the results you what. Once that is done then bring it into the main report and pass what where parameters you need from main to the sub-report.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial