Drill down report in SSRS
Posted on 2010-08-26
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...