Excel transformation performance

[joshuaguilty]

I have a report which is working perfectly, and it could be saved as an Excel sheet. The only thing is it takes a long time to open, but when it is opened and re"Saves as" another Excel sheet; the newly saved one reacts right away. The question I would like to ask is whether there is some settings in the Reporting Services to save a 'light' Excel sheet? Any ideas !?

 

[xlbo]

the time taken is to convert the rdl to something that excel can understand and then create. It works quicker afterwards as it doesn;t need to do this (it is already in excel).

AFAIK you cannot control how RS outputs the data to excel without creating your own rendering program

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[joshuaguilty]

Thank you and it looks like I have to re-save the original file to a 'light'er one.