I'm relatively new to SSRS, having created a few small reports which reference a simple stored procedure to get data. But I have a whopper assigned to me. It's not necessarily difficult, just huge. The finished report is to be a collection of approx. 20 tablix, each with 7 columns and 6 rows. Each cell is a total COUNT from a sql query (i.e. SELECT COUNT(*) FROM table).

Surely there must be a more efficient way than creating a separate dataset for each cell in 20 tables. That's hundreds of datasets.

I thought of creating a temp table in my stored procedure housing all of the data, but that still involves hundreds of individual datasets involving a SELECT COUNT(*) query.