开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜