question

Raj More avatar image
Raj More asked

Do not rerun the query

As I format my SSRS reports, it re-runs the query every time I switch from Design to Preview. Is there any way for me to tell it to cache the data so I focus on my formatting without having to wait for the query execution each time?
sql-server-2008-r2ssrs
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

3 Answers

·
Raj More avatar image
Raj More answered
Apparently, this is a known bug and Microsoft has issued a cumulative patch that fixes this http://support.microsoft.com/kb/2282505
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image Fatherjack ♦♦ commented ·
Good research there. :) and congrats on getting over the 1k karma points.
1 Like 1 ·
Fatherjack avatar image
Fatherjack answered
it should be using a cached set of data - look in your project folder, are there .rdl.data files in there?
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
Agreed. I've just been looking at some SSRS projects on my computer, and they're still showing sample data from the system I developed 'em against, 6 months and one job ago.
0 Likes 0 ·
Raj More avatar image Raj More commented ·
I am on 2008-R2 and I do not see a single `.rdl.data` file on my development machine. Is there a setting I have unchecked somewhere?
0 Likes 0 ·
xnl28 avatar image
xnl28 answered
In the file RSReportDesigner.config, there is a setting CacheDataForPreview. If you set this to TRUE, it should cache the report data and not hit the database again. See http://msdn.microsoft.com/en-us/library/ms160346.aspx for more details. The config file is usually located in C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies. However, when I try this, I also see that the Report Designer hits the database each time. This is possibly a bug. I logged a bug Feedback entry at Microsoft Connect https://connect.microsoft.com/SQLServer/feedback/details/661298/cachedataforpreview-setting-in-rsreportdesigner-config-not-honoured
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.