Solved

SSRS Sub reports and passing parameter values

Posted on 2012-12-31
3
674 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SSRS Graph - Stacked Bar 2 48
Highlight a field based on value in another field in SSRS 4 37
SSRS Calculation help 6 37
SSRS MONTHNAME and IIF 16 56
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

867 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now