CODEWITHSUNDEEP
sqlperformancereporting-services
Serdia
Serdia

Reputation: 4428

Why does SSRS taking too long to execute in design and more while building it?

I have two data-sets in my SSRS tool, first table contain 12,000 records and second one 26,000 records. And 40 columns in each table.

While building a report each time I go preview - it takes forever to display. Is any way to do something to avoid that, so I can at least not spent so much time to build this report?

enter image description here

Thank you in advance.

Upvotes: 1

Views: 71

Answers (2)

BIDeveloper
BIDeveloper

Reputation: 2638

@vercelli's answer is a good one. In addition you can change your cache options in the designer (for all resultsets including patramters) so that the queries are not rerun each time.

This is really useful plus - a couple of tips for you: 1. I don't recommend caching until you are happy with the your dataset results. 2. If you are using the cache and you want to do a quick refresh then the data is stored in a ".data" file in the same location as a your .rdl. You can delete this to query the database again if required.

Upvotes: 0

vercelli
vercelli

Reputation: 4767

Add a dummy parameter to limit your dataset. Or just change your select to select top 100 while building the report

Upvotes: 1

Related Questions