Hi, I have set of two reports like drill through report. If you click on one report1 (Customer Summary) it jumps to report2 (Customer Detail). Is there a way instead of going it to another report, I can show the report 2 to same report page (may be by showing two matrix or tables)?. (I am passing CustomerID parameter from report1 to report 2) Thank You

Please use drilldown functionality in ssrs. Display default report for your main (Summary) report and hide the rows(details) by setting hidden property for the details group. Once they want to see the detail report they will click on the summary so thay way you can achieve both reports in 1. Thanks Hardik --- Plz mark as Answer if your problem is resolved.

Hi, I have set of two reports like drill through report. If you click on one report1 (Customer Summary) it jumps to report2 (Customer Detail). Is there a way instead of going it to another report, I can show the report 2 to same report page (may be by showing two matrix or tables)?. (I am passing CustomerID parameter from report1 to report 2) Thank You OF Course ! Look into SUBREPORT option . Thanks .Rajkumar Yelugu

Hi, as Hardik mentioned, it is the drilldown feature in SSRS you need to use to display detail set of records for a given summary row within the same report. Please refer Creating Drilldown hieararchial report in SSRS for more details. Hope this helps. Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH

No Guys, its not drill down report. I am looking for if i click on a value on one table\matrix, other table\matrix should get updated. Thanks

Hi Farrukh, For your description, you want to click a value on the first table/matrix, then the second table/matrix should get updated based on the value you clicked. If so, we could still use the drill through feature to achieve this. We should add a parameter for the report firstly, and then add an action in the first table/matrix, using the drill through feature to pass the value which is clicked on the first table/matrix to the parameter. Lastly, we should add a filter on the second table/matrix, using the parameter value to filter data. For example, I have a report is named Report1 and a dataset is named DataSet1. The DataSet1 includes four fields which are Category(Accessory, Bike, Clothing and so on), SubCategory, Product and OrderQuantity. In order to achieve it, please refer to the steps below: 1. Add a parameter to receive the value which is clicked on the first table/matrix. 1> In the Report Data window, add a parameter which is named Category. 2> Select “Hidden” option to hide the parameter, and add a default value(eg:Bike). 2. Add an action in the first table/matrix to pass the value to the parameter. 1> Drag a table from the Toolbox to the design surface, design my first table like this: Category [Category] 2> Right-click the [Category] field and then select “Text Box Properties”. In the Text Box Properties page, click Action. 3> In the “Action” page, select “Go to report” option. In the drop-down list of the “Specify a report” section, select Report1(Particular attention: the report should drill through itself). 4> In the “Use these parameters to run the report:” section, click Add. For name column, please select the parameter you created in step one. Set the “Name” and “Value” like this: Name Value Category [Category] 3. Add a filter in the second table/matrix. 1> Drag another table from the Toolbox to the design surface, and design my second table like this: Sub Category Product Order Quantity [SubCategory] [Product] [OrderQuantity] 2> Right-click the second row of the table, and select Tablix Properties. In the Tablix Properties page, click “Filters”, and then click “Add”, set the expression like this: Expression: [Category] Operator: = Value: [@Category] After previewed the report, I can click the Clothing of category in the first table, then the second table is based on the Clothing value automatic to refresh data. If you have any question, please feel free to ask. Best Regards, Bin Long

Hi Bin, I appreciate the help, is there any working report demonstrating it out there? perhaps something utilizing the adventureworks. Is it possible if you can email me the solution. I am not sure why everyone is refering to drill through. Let me put the exact scenario i am dealing with. I have a map report utilizing the geospatial location showing the customer locations on the map report. What i am trying to do is when a client click on the location of the customer on the map report, a table on the same report should show the detail of that customer. I hope i am more specific now. SO far i am able to achieve 1-If I click on the location of customer on the map, it jumps to another report(sub report) showing the detail of the customer. What i am trying to do now is to show the customer detail on the same page somehow. Thank You

I tried to use the logic you have provided, seems like i am close to the solution, I am getting the following error "An attempt was made to set a report parameter "@Category" that is not defined in this report.