1

I have one report in which I have table like below,

This is what report looks like

Now as for change I need to add the second table for each customer and the new report should look like as below,

Expected report look

So basically, I want to repeat two tables for each customer there will be multiple customers or single customer. I tried following this answer but with no luck. (The table should always visible so can not go with the drill down report.) Any help would be great. My reporting server is 2008 r2.In case of the problem or confusion feel free to comment.

Community
  • 1
  • 1
Mahesh
  • 8,694
  • 2
  • 32
  • 53

2 Answers2

2

You need to place it(the table) in a list object. And configure the grouping of the list and filtering of your table.

Jacob Siemaszko
  • 346
  • 1
  • 5
  • 20
  • but list can operate and bind to the one dataset at the time. But i have multiple tables which will be need to bind to the multiple datasets. Thanks though, for taking your time. – Mahesh Jan 12 '15 at 15:26
  • So if you have a fixed ammound of datasets, why using dynamic number of tables ? – Jacob Siemaszko Jan 12 '15 at 15:35
2

Similar to Jacob's answer, but make a subreport that handles all the tables and datasets for one single customer.

Then use a list object that is populated by a dataset of all the customers you want to display, and put the subreport in the list object, passing the customerId to the subreport.

Tab Alleman
  • 31,483
  • 7
  • 36
  • 52