Solved

SSRS Limit SubReport to only records to results for that group

Posted on 2015-01-26
3
372 Views
Last Modified: 2015-01-26
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.
0
Comment
Question by:rcowen00
  • 2
3 Comments
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40570439
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
 

Author Comment

by:rcowen00
ID: 40570517
Yes, I had already found and followed that tutorial and it either shows all records or I get the error I noted.
0
 

Author Comment

by:rcowen00
ID: 40570534
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

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql query 8 48
SQL Server - executing an agent job from a stored proc 2 18
List<PaisEntity> - show some 1 24
RLDC Reporting in Visual studio 11 13
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

785 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