Inconsistent Excel Exports

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
The British LibraryOn Jun 28, 6:15 am, Chloe C <c...@.mcrowdd.plus.com> wrote:
> 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
> The British Library
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