?
Solved

Drill down report in SSRS

Posted on 2010-08-26
8
Medium Priority
?
398 Views
Last Modified: 2012-06-27
Okay I have two stored procs,
getCustomers
GetOrders(@CustomerNumber)

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...
0
Comment
Question by:talker2004
7 Comments
 
LVL 27

Accepted Solution

by:
planocz earned 2000 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.
0
 
LVL 7

Author Comment

by:talker2004
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?
0
 
LVL 5

Expert Comment

by:almander
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.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 5

Expert Comment

by:almander
ID: 33547401
Here is a screenshot
rs-nav.png
0
 
LVL 27

Expert Comment

by:planocz
ID: 33548006
Thanks almander,
I have not had time to get back answer to this one.
0
 
LVL 5

Expert Comment

by:almander
ID: 33579113
Understood
0
 
LVL 101

Expert Comment

by:mlmcc
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.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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 …
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

850 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