New feature! Upgrade and increase expert visibility of your issues with Priority Questions.
Solved
SSRS Sub reports and passing parameter values
Posted on 2012-12-31
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?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3 Comments
Active today
Insert Sub Report. Go to Subreport property and follow the image as you see to pass parameter.
Active 2 days ago
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.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column.
…
How to use Variables and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS.
Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment.
To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month9 days, 7 hours left to enroll
610 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.