sql server reporting services: Inconsistent Excel Exports -- sql server reporting services

Inconsistent Excel Exports

Chloe C
6/28/2007 12:15:49 PM

sql server reporting services: Hi

We've got a oddity when exporting to Excel. If you export the same
report to Excel twice in sucession (don't refresh between - just
export) some report give different results between exports, with some
columns being shifted. Subsequent exports seem to be conistent.

The problem may be related to images on the reports - not sure yet.

Has anyone else encountered this, and is there a workround (other than
not using images in our standard header format).

Chloe Crowder

Re: Inconsistent Excel Exports

EMartinez
6/29/2007 8:02:49 PM

[quoted text, click to view]

The first thing you should check is to make sure that you have the
latest MS Office updates and the latest SQL Server SP. Also, I would
look into index tuning for better performance of the query/stored
procedure that is used in the report. If you are using SQL Server
2005, run the query/stored procedure in the Database Engine Tuning
Advisor, if you are using SQL Server 2000, run it against the Index
Tuning Advisor/Wizard. Hope this helps.

Regards,

Enrique Martinez
Sr. Software Consultant