Exporting a report to a text file

Is there anyway to export a report to a text file in SQL Reporting Services?
Thanks
Zack GallingerYou can export to the .csv format from the Report Viewer if you're running
MSSQL 2005 Standard or Enterprise. Express and Workgroup versions of MSSQL
2005 do not offer that feature.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Zack" <Zack@.discussions.microsoft.com> wrote in message
news:73DCD5BB-93DB-4BDD-A565-9B087183F958@.microsoft.com...
> Is there anyway to export a report to a text file in SQL Reporting
> Services?
> Thanks
> Zack Gallinger|||On Dec 5, 12:27 pm, "Alain Quesnel" <alainsanss...@.logiquel.com>
wrote:
> You can export to the .csv format from the Report Viewer if you're running
> MSSQL 2005 Standard or Enterprise. Express and Workgroup versions of MSSQL
> 2005 do not offer that feature.
> Alain Quesnel
> alainsanss...@.logiquel.com
> www.logiquel.com
> "Zack" <Z...@.discussions.microsoft.com> wrote in message
> news:73DCD5BB-93DB-4BDD-A565-9B087183F958@.microsoft.com...
> > Is there anyway to export a report to a text file in SQL Reporting
> > Services?
> > Thanks
> > Zack Gallinger
Actually, exporting to CSV is an option in the Express Edition as
well. Of course, you also have the option of using URL access to
export a report to a specific format as well. This link should be
helpful. http://msdn2.microsoft.com/en-us/library/ms153586.aspx. If
you need the report exported programmatically, you can access the
report and export it to CSV/etc via the ReportServices Web Service
(http://msdn2.microsoft.com/en-us/library/
microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx ).
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||I based my answer on this:
http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx
Did I misinterpret?
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
>
> Actually, exporting to CSV is an option in the Express Edition as
> well. Of course, you also have the option of using URL access to
> export a report to a specific format as well. This link should be
> helpful. http://msdn2.microsoft.com/en-us/library/ms153586.aspx. If
> you need the report exported programmatically, you can access the
> report and export it to CSV/etc via the ReportServices Web Service
> (http://msdn2.microsoft.com/en-us/library/
> microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx
> ).
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Dec 5, 10:21 pm, "Alain Quesnel" <alainsanss...@.logiquel.com>
wrote:
> I based my answer on this:http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx
> Did I misinterpret?
> Alain Quesnel
> alainsanss...@.logiquel.com
> www.logiquel.com
>
> > Actually, exporting to CSV is an option in the Express Edition as
> > well. Of course, you also have the option of using URL access to
> > export a report to a specific format as well. This link should be
> > helpful.http://msdn2.microsoft.com/en-us/library/ms153586.aspx. If
> > you need the report exported programmatically, you can access the
> > report and export it to CSV/etc via the ReportServices Web Service
> > (http://msdn2.microsoft.com/en-us/library/
> > microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx
> > ).
> > Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
This documentation seems to be out of date. Currently, all options
available for export in SSRS Std Edition are also available in SSRS
Express Edition w/Advanced Services.
Regards,
Enrique Martinez
Sr. Software Consultant