Excel Export of SSRS Report shows outdated data

Question

I have an SQL Server Reporting Services (SSRS) report, that uses a view. That few had to be adjusted yesterday. Now the report shows online the correct data, however as soon as I click on export to Excel it seems to bring to outdated data. Opening the Excel yields data that was correct before the view adjustment. Is this Excel Version somewhere cached ? Or what could explain this strange behavior ?

Answer 1

How are you running the report? From the designer. If so, you do get caching issues unless a parameter has changed.

If running from your reporting server check that no versions of EXCEL.exe are running.

Also, is this the same behaviour on all users PC's?

Answer 2

I found now that it is related to grouping records, when I have two grouping levels on the report these duplicate rows appear. When I have only one grouping level then it works. So what I assumed is outdated data, was just a coincidence of my view change with a general bug in the excel export. Seems that it is a known bug, however MSFT seems not very eager to ship a fix.