I have to build a report where I will have an incoming parameter CustomerGroupId. The CustomerGroup has a one to many to Customers and then Customers has multiple Ancillary tables associated to a CustomerId for example. I need to create a rollup type report where I get the CustomerGroupId and then I will have several pages for each Customer I will need to pull together so for example each ancillary table will have a page.
I have worked with the Tablix before but at the end of the day I need to loop through and for each Customer in the Customer group create a multi page type report right after each other for each customer in the group. Is this possible in SSRS as far as looping though a main dataset and creating a multi page type report for this?