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
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.
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.


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 100

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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Changing the datatype of a column from nvarchar to date 47 17
MS SQL Delete Query 9 30
SSRS  - Dropdown with Null 3 24
ms sql + get number in list out of total 7 26
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: (…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

808 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