x

SSRS 2005 Not Always Refreshing

At times, when we open an existing SSRS report for data audits, the data tab refreshes data properly but when we go to the preview tab, the data is not refreshed in the report. We can click on the refresh button and it will usually refresh but is there any way to do this programatically or when preview tab is clicked?

more ▼

asked Apr 27, 2010 at 10:07 PM in Default

Tom Redd gravatar image

Tom Redd
57 4 4 4

(comments are locked)
10|1200 characters needed characters left

3 answers: sort newest

When you are editing a report in BIDS you have a subtly different kind of access to the data when compared with access to a report that is served from a report server. The data tab executes the query to the data source when you request a refresh, the preview tab is different again, in that when you run it the data can be cached in your BIDS project (you will see a file in the same folder as the report, with the same name but with a .data file extension) so that the preview tab loads more quickly. This can lead to you seeing 'old' data while you are developing the report.

As Daniel Ross has already suggested, the best way forward for you is to deploy the report to a report server so that it can be serving up-to-date data when it is required.

more ▼

answered Apr 28, 2010 at 03:44 AM

Fatherjack gravatar image

Fatherjack ♦♦
42.7k 75 79 108

(comments are locked)
10|1200 characters needed characters left

If you are viewing the report locally via visual studio / business intelligence development studio, then the following applies:

  1. Go to the directory of your solution (where the .rdl files are stored)
  2. Delete all files with a ".rdl.data" extension
  3. Refresh the preview.

I have sometimes found it necessary to rebuild the reporting service project after deleting all the .rdl.data files, but I'm fairly sure that only applies when I've actually changed the report itself.

more ▼

answered May 17, 2010 at 02:33 PM

user-470 gravatar image

user-470
277 19 19 21

(comments are locked)
10|1200 characters needed characters left

It is designed to do that, and I don't think it can be changed. You could create a macro and map it to a shortcut, but I think it would be more work than simply clicking refresh when you open the preview tab.

It sounds like you are using visual studio to run the reports? I would deploy the report (if you have SSRS installed on a server) and make sure that "Do not cache temporary copies of this report" in the report execution properties on the server is ticked.

more ▼

answered Apr 28, 2010 at 12:57 AM

Daniel Ross gravatar image

Daniel Ross
2.9k 10 13 14

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x554
x35

asked: Apr 27, 2010 at 10:07 PM

Seen: 3352 times

Last Updated: Apr 28, 2010 at 03:45 AM