Solved

SSRS Sub reports and passing parameter values

Posted on 2012-12-31
3
681 Views
Last Modified: 2013-01-02
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?
0
Comment
Question by:spoye
[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
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 38734052
Insert Sub Report. Go to Subreport property and follow the image as you see to pass parameter.

Parameter
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 38734338
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)?
0
 
LVL 27

Accepted Solution

by:
planocz earned 500 total points
ID: 38734577
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.
0

Featured Post

Guide to Performance: Optimization & Monitoring

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.

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: …

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.

Join & Ask a Question