Export reports to Excel (data only)

Hi,
Crystal Enterprise have an export option called "Export 97-2000 (data
only)" which exports a report to Excel format but just the data and
not the formatting. I'd like to get similar functionality with
reporting services.
I've tried using the "CSV" format which kinds of does a similar job
but it spreads everything out wide and both the header and table
groups gets mangled together.
What's the best way of accomplishing this in Reporting Services?
Are there any plans to have a different Excel export option that only
exports the data like Crystal?
TIA,
Magnus LassiWe don't have any plans for an Excel-specific data-only renderer at this
point (but that may change if enough people ask for it).
The CSV renderer should be able to give you what you're looking for after
you set the DataElementOutput property to suppress columns you don't want to
see.
--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"Magnus" <mlassi@.yahoo.com> wrote in message
news:f85791fa.0407090735.11ce8969@.posting.google.com...
> Hi,
> Crystal Enterprise have an export option called "Export 97-2000 (data
> only)" which exports a report to Excel format but just the data and
> not the formatting. I'd like to get similar functionality with
> reporting services.
> I've tried using the "CSV" format which kinds of does a similar job
> but it spreads everything out wide and both the header and table
> groups gets mangled together.
> What's the best way of accomplishing this in Reporting Services?
> Are there any plans to have a different Excel export option that only
> exports the data like Crystal?
> TIA,
> Magnus Lassi