SSRS different results in Data tab and Preview tab

Question

I get the correct results (nov and dec data) when I run a query in the Data tab of a report that I built in SQL Server Reporting Services. When I preview the report I get old data from October. It doesn't make any sense to me. I'm not sure whats going on. Note: the data is in Oracle.

Here's the date filter I'm using

receipt_date + 2 <= SYSDATE

The query works fine in SQL Developer and in the Data tab in the .rdl designer in visual studio...just not in the Preview tab when run the report..that's when I get Oct. data.

Anyone know what's going on here?

Answer 1

Is there anything different regarding the dataset's parameters? Do report parameters feed the dataset at all? If so what are they? Is the report a server report? If so what is the time set to on the server?

Answer 2

There are no report parameters.....the exact same sql is run everytime. I'm not sure what you mean when you ask if the report is a server report.

Answer 3

I think we are experiencing the same problem. At least same-ish. Reading data from an oracle sp. We get three rows like this if we run the preview query in the data tab.

COL1 COL2
A    1
B    0
C    3

But if we put them in a table in a report we are developing all we get is this:

COL1 COL2
A    0
B    0
C    0

Trying on another machine doesn't help. Neither does deploying. The annoying thing is that creating a new report using the wizard with only this data in it works.

Sorry for not being of any help, just hoping this would add some clues...

Answer 4

i have one theory that i haven't been able to test. this report is not deployed to Report Manager but is being run from Visual Studio. I don't know if that makes a difference.

Answer 5

Hi,

SSRS caches data locally for use by the designer. The cached data is only updated if the developer previews the report in VS.NET using a different set of parameters, which in your case never happens because the report has no parameters.

To allow SSRS to refresh the cached data, navigate to the directory which contains your design-time RDL file and delete any files which have the extension ".data".

Hope this helps,

Bill

Answer 6

see the links http://connect.microsoft.com/SQLServer/feedback/details/522670/ssrs-turn-off-local-data-cache-in-bids#

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/145ac9ac-b247-47d2-a787-98a8fcfad053