SSRS Limit SubReport to only records to results for that group

Hi Experts,

I have a SSRS report with a Matrix that show results for a location.  I have added a subreport of sales and can't figure out how to only show results for that store.  I tried limiting the subreport by location, then I get the same sales for all locations. If I don't have the location as a parameter in the  stored procedure of the sales and link by location from main to subreport I get an error.  Subreport could not be shown....An attempt was made to set a reprot parameter 'Location' that is not defined in this report.  Seems like it should be a straight forward thing, but I am missing it.  Any help is appreciated.
rcowen00Asked:
Who is Participating?
 
Phillip BurtonConnect With a Mentor Director, Practice Manager and Computing ConsultantCommented:
See if this page has the answers for you: https://msdn.microsoft.com/en-us/library/dd220581.aspx

It is a step-by-step Guide to creating a subreport.

I can also recommend the book SQL Server 2012 Reporting Services Blueprints, which focuses on things like parameters, and Chapter 3 includes subreports.
0
 
rcowen00Author Commented:
Yes, I had already found and followed that tutorial and it either shows all records or I get the error I noted.
0
 
rcowen00Author Commented:
I think I figured out my issue.  It seems to be working fine if I add all data regions to a rectangle and have no parameter to the subreport.
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.

All Courses

From novice to tech pro — start learning today.