Sunday, February 19, 2012

Integrating Reports into existing ASP.NET site/app...

We have been creating reports using SSRS but would like our users to request
reports through a custom interface NOT the standard SSRS interface. So as
far as I know there are 3 ways of presenting SSRS reports to users:
1) Report Manager
2) Reports through URL
3) SSRS Web Services
1 and 2 are simple, but require that the user experience SSRS look and feel,
including all navigation whereas the Web Services can be used to allow the
user to interact with reports that will have the same look and feel as the
site for which they are being integrated.
Is this a fair assessment? What in your opinion is the best way to integrate
SSRS reports into a site so the user will get to pick report params via web
controls custom to the site but then view the report with the zooming,
paging and exporting
that you get free with Report Manager?
**Note I have looked at and got to run the
Microsoft.Samples.ReportingServices.ReportViewer, and maybe this is the best
way. But can this be used when presenting the user with an alternative way
of providing parameters?
Thanks all in advance.I am using ReportViewer component in my current asp.net web site. You can
find this component in x:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\Samples\Applications\ReportViewer. There is
c# and vb.net code available. You need to compile it first. And this link is
also helped me much at the begining;
http://www.odetocode.com/Articles/128.aspx (dont forget to read part two)
Hope this helps,
Regards.
"Terry Mulvany" <terry.mulvany@.rouseservices.com> wrote in message
news:#G#BlW72EHA.3380@.TK2MSFTNGP09.phx.gbl...
> We have been creating reports using SSRS but would like our users to
request
> reports through a custom interface NOT the standard SSRS interface. So as
> far as I know there are 3 ways of presenting SSRS reports to users:
> 1) Report Manager
> 2) Reports through URL
> 3) SSRS Web Services
> 1 and 2 are simple, but require that the user experience SSRS look and
feel,
> including all navigation whereas the Web Services can be used to allow the
> user to interact with reports that will have the same look and feel as the
> site for which they are being integrated.
> Is this a fair assessment? What in your opinion is the best way to
integrate
> SSRS reports into a site so the user will get to pick report params via
web
> controls custom to the site but then view the report with the zooming,
> paging and exporting
> that you get free with Report Manager?
> **Note I have looked at and got to run the
> Microsoft.Samples.ReportingServices.ReportViewer, and maybe this is the
best
> way. But can this be used when presenting the user with an alternative
way
> of providing parameters?
> Thanks all in advance.
>
>

No comments:

Post a Comment