Excel Export of SSRS Report shows outdated data
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 ?
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?
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.
精彩评论