CODEWITHSUNDEEP
reporting-servicesssrs-2008-r2ssrs-grouping
Mahesh
Mahesh

Reputation: 8892

How to repeat multiple tables in report For multiple values?

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.

Upvotes: 1

Views: 2683

Answers (2)

Tab Alleman
Tab Alleman

Reputation: 31785

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.

Upvotes: 2

Jacob Siemaszko
Jacob Siemaszko

Reputation: 346

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

Upvotes: 2

Related Questions