SSRS report with each category a separate table/grid

Question

I am using BIDS and SQL Server Reporting Services (SSRS) 2008 R2 to build a report. And I want the each category to show as a separate table/grid.

Important: the columns (CELERY, EGG etc) are dynamic and come from values in a table, so the person building the report cannot hard-code them into the report. So we are using a matrix control at the moment.

What the report looks like now:

How I would like the report to look:

Any ideas?

Thanks, Craig

Answer 1

Use a list ontrol and put the matrix inside the list. Use the category as your grouping for the list. Add a textbox just above the matrix to display the category.