SSRS Sub reports and passing parameter values

steven
steven used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Alpesh PatelSolution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)

Commented:
Insert Sub Report. Go to Subreport property and follow the image as you see to pass parameter.

Parameter
ValentinoVBI Consultant
Most Valuable Expert 2011

Commented:
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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial