Monday, March 19, 2012

A stupid SQL RS question

Hello everyone,
I am newbie to SQL RS and just got it installed on my laptop. I wanted
to know if the following is possible with SQL RS or do I need to use a thrid
party tool. Here is what I want to do:
I have a search website where users can query certain (SQL) databases
and generate reports. Currently the reports are in HTML format and I using
ASP.NET to do all the searching and report displaying.
Is it possible to provide a report save option which will convert the
generated report into PDF/EXCEL/TEXT/etc? Can I make use of SQL RS or do I
have to use a thrid party software like ASP2PDF'
thank you all in advance,
BIYou have multiple options for rendering formats. See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPORTAL/HTM/rs_gts_portal_3vqd.asp
--
-- John H. Miller [MSFT]
-- SQL Server BI Product Group
----
--
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
----
--
"bhai" <bhai@.vt.edu> wrote in message
news:e3asQNadEHA.3512@.TK2MSFTNGP12.phx.gbl...
> Hello everyone,
> I am newbie to SQL RS and just got it installed on my laptop. I wanted
> to know if the following is possible with SQL RS or do I need to use a
thrid
> party tool. Here is what I want to do:
> I have a search website where users can query certain (SQL) databases
> and generate reports. Currently the reports are in HTML format and I using
> ASP.NET to do all the searching and report displaying.
> Is it possible to provide a report save option which will convert the
> generated report into PDF/EXCEL/TEXT/etc? Can I make use of SQL RS or do
I
> have to use a thrid party software like ASP2PDF'
> thank you all in advance,
> BI
>|||Use the Reporting Services Web Service (SOAP API) for programmatic exporting
of reports. The method you want is "Render".
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"bhai" <bhai@.vt.edu> wrote in message
news:e3asQNadEHA.3512@.TK2MSFTNGP12.phx.gbl...
> Hello everyone,
> I am newbie to SQL RS and just got it installed on my laptop. I wanted
> to know if the following is possible with SQL RS or do I need to use a
thrid
> party tool. Here is what I want to do:
> I have a search website where users can query certain (SQL) databases
> and generate reports. Currently the reports are in HTML format and I using
> ASP.NET to do all the searching and report displaying.
> Is it possible to provide a report save option which will convert the
> generated report into PDF/EXCEL/TEXT/etc? Can I make use of SQL RS or do
I
> have to use a thrid party software like ASP2PDF'
> thank you all in advance,
> BI
>

No comments:

Post a Comment