I need help please.
I have an ssrs report, that has 2 parameters. Company and Product.
Company A - Product 1
Company B - Product 3
Product 4 etc
I have one main dataset with data as follows:
Region, Product, Value
I need to somehow create a different tablix for each region, as we need to export the report to Excel, and each region needs to be a separate sheet, with sheet name (Product - Region).
Iv'e created a region row grouping. This works if I filter the group, and I hardcode the region name. However not all the regions have data for a particular product. This now produces an empty sheet.
Is there any way to make the group filter dynamic? To somehow loop through the regions in the dataset and create a tablix for each region?
Or should I use a different approach?
Any help will be greatly appreciated.