Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 711
  • Last Modified:

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?
0
steven
Asked:
steven
1 Solution
 
Alpesh PatelAssistant ConsultantCommented:
Insert Sub Report. Go to Subreport property and follow the image as you see to pass parameter.

Parameter
0
 
ValentinoVBI ConsultantCommented:
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
 
planoczCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now