On Jun 17, 1:05 pm, rafael <[email protected]> wrote:
> I am exporting excel from reporting services, however if the data is
> large, it takes a very long time to generate...is there any way to
> optimize the speed ? If the excel is generate, its around 5 MB, takes
> 3 minutes to generate.... however to generate the report to the web,
> its fast...
>
> Is there a service pack to update on this or is a solution for this ?
>
> Thank You
Hi,
fastest way to export data to Excel is by using 3rd party component.
Try using GemBox.Spreadsheet component - it is free to use for smaller
files (limit is 150 rows).
http://www.gemboxsoftware.com/GBSpreadsheet.htm
