combine 2 reports in 1 report
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
April 22nd, 2011 12:41pm
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.
Free Windows Admin Tool Kit Click here and download it now
April 22nd, 2011 1:45pm
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
April 22nd, 2011 4:40pm
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
Free Windows Admin Tool Kit Click here and download it now
April 23rd, 2011 3:37am
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
April 25th, 2011 4:08pm
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
Free Windows Admin Tool Kit Click here and download it now
April 26th, 2011 5:43am
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
April 26th, 2011 3:15pm
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.
Free Windows Admin Tool Kit Click here and download it now
April 27th, 2011 10:16am