Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.
Course Of The Month
6 days, 23 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
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 1 day ago
Insert Sub Report. Go to Subreport property and follow the image as you see to pass parameter.
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)?
Active 2 days ago
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
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss. This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in. And this behavior is only see…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have.
In this…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query:
…
Suggested Courses
Course of the Month6 days, 23 hours left to enroll
724 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.