Drill down report in SSRS

Posted on 2010-08-26
Last Modified: 2012-06-27
Okay I have two stored procs,

So I have two datsets in the report DataSet1 uses GetCustomers, DataSet2 uses GetOrders and has 1 parameter for the customer number.

I already have a grid layed out that displays all of the cusotmers exactly the way I want it, Now what I need is that when the user clicks on the customer from the screen It should open up a report with all of the customers orders.

When the user clicks it will need to pass the customer number that was clicked into the getOrders stored proc and then display all of the customers orders. I am not sure if this is setup as a seperate report or a sub report.

Please someone give me some guidence on how I would accomplish this.

thanks in advance...
Question by:talker2004
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 27

Accepted Solution

planocz earned 500 total points
ID: 33536376
Have you tried making a sub-report for the click on customer?
The sub-report runs like a single report but uses the parameters from the main report.

Author Comment

ID: 33536609
How do you tell the sub report to launch using the customerid as the parameter when the click on one of the customers in the table?

Expert Comment

ID: 33538914
Right click on the Customer Id Textbox, and select properties.

You should see a navigation tab, on that tab select:
Jump to Report, the Report you want to jump to, and to the right you will be able to set the parameters for the new report.
Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.


Expert Comment

ID: 33547401
Here is a screenshot
LVL 27

Expert Comment

ID: 33548006
Thanks almander,
I have not had time to get back answer to this one.

Expert Comment

ID: 33579113
LVL 101

Expert Comment

ID: 34533081
This question has been classified as abandoned and is being closed as part of the Cleanup Program.  See my comment at the end of the question for more details.

Featured Post

Comparison of Amazon Drive, Google Drive, OneDrive

What is Best for Backup: Amazon Drive, Google Drive or MS OneDrive? In this free whitepaper we look at their performance, pricing, and platform availability to help you decide which cloud drive is right for your situation. Download and read the results of our testing for free!

Question has a verified solution.

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

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

707 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