Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fralo
Posting Yak Master
161 Posts |
 Posted - 2013-08-22 : 11:52:27
|
| Hi all,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.I would greatly appreciate any advice or suggestions you might have.Thank you. |
|
|
|
|
|
Advice on how to create large report