SSRS Limit SubReport to only records to results for that group
Posted on 2015-01-26
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.