"Joel" <Joel@discussions.microsoft.com> wrote in message
news:2B69B45B-7708-4D11-8C35-B58A0BC2213B@microsoft.com...
> We have run into a critical performance issue with Excel rendering
> extension.
> Is there any way, undocumented or not, to render to MS Excel without
> formatting? I have searched this group and other resources and it looks
> like
> the answer is no. Though, I thought I would try just in case.
>
> Microsoft, please chalk this up as a load plea for this feature ASAP. In
> short, my user base is comparing the export performance of Crystal Reports
> and MSRS Excel exports. For example, a query rendered unformatted to
> Excel
> in Crystal takes 60 secs where as is taking 15 minutes for MSRS to render
> the
> same Excel file. Since most of our analysts run reports and then export
> the
> data to further analyze it, this performance difference is painful.
>

"Joel" <Joel@discussions.microsoft.com> wrote in message
news:A7F8E479-DAD1-4474-9F65-6AD449103C60@microsoft.com...
> Jeff, thanks for the suggestions! We are using CSV at the moment as a
> work-around. By the way, if you set <TAB> as the delimiter, there is no
> need
> to perform "text to columns". :)
>
> Unfortunately, grouping rows are being translated into extraneous columns
> when the reports are exported to CSV. Even worse, most of our reports
> have a
> sub-report at the top which makes the CSV output even more worthless.
> This
> means that analysts have to delete a lot of columns before they can
> actually
> use the Excel data. This CSV work-around is really not an acceptable
> long-term option.