Excel Export not working - holds on to old data

[kdooley]

I am running into an error in Reporting Services 2003 when I export to Excel.

If I run a report and then export it in any other format (csv, pdf, etc.), it works fine. But if I run it and then export to Excel, it gives me a report that was run by someone at some other time.

I have tried the &rs:ClearSession=True at the end of the url and that does not help because the report is working correctly. It's only when I export to the Excel format.

Has anyone else run into this issue? Any suggestions?

Thanks!

 

[Catadmin]

Is it trying to save the export to a file of the same name every time?

I.E., you tested it with the name of "MyExcelReport" and now, because that file exists it won't allow you to overwrite?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[kdooley]

Yes, it is using the same file name.

Since I posted this message two weeks ago, I have done more research and think that I have found a possible bug in Reporting Services on Exports to Excel and the Web Archive when using Snapshots in the Standard Verison (not the Enterprise Version).

In the Temp tables, the SnapshotDataID is being overwritten when you do an export, so it goes back and finds the first export run that day (the snapshot is deleted sometime during the night) and exports it everytime you export.

There are some other issues with the Web archive that behave almost in the same way.

Has anyone else seen this?

 

[Catadmin]

I haven't seen this issue. However, we're not exporting to Excel. We're rendering all our reports in .pdf.

Glad to hear you've been able to find something on the problem though. I thought it might be the fact that Excel didn't like the already existing file so wanted you to save it under a different file name.


Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"