Reporting Services

I have a hard time figuring out how the web service part is being
used. Has anyone done this? We are looking for a web service kind of
feature.
ThanksWhat are you trying to do? RS has very very strong support for web services.
Indeed, Report Manager in RS 2005 does everything it does using web
services. Books online has a whole ton on web services.
But, to back up, unless you are doing something fancy you are better off to
use the webform or winform that ships with VS 2005. Or in other cases look
at the URL integration. But, I would recommend using the controls from VS
2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ross" <ross_smith@.csaa.com> wrote in message
news:e7450aef-4d07-43df-8c87-1675739e884c@.s13g2000prd.googlegroups.com...
>I have a hard time figuring out how the web service part is being
> used. Has anyone done this? We are looking for a web service kind of
> feature.
> Thanks|||On Feb 21, 7:41=A0am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> What are you trying to do? RS has very very strong support for web service=s.
> Indeed, Report Manager in RS 2005 does everything it does using web
> services. Books online has a whole ton on web services.
> But, to back up, unless you are doing something fancy you are better off t=o
> use the webform or winform that ships with VS 2005. Or in other cases look=
> at the URL integration. But, I would recommend using the controls from VS
> 2005.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Ross" <ross_sm...@.csaa.com> wrote in message
> news:e7450aef-4d07-43df-8c87-1675739e884c@.s13g2000prd.googlegroups.com...
>
> >I have a hard time figuring out how the web service part is being
> > used. Has anyone done this? We are looking for a web service kind of
> > feature.
> > Thanks- Hide quoted text -
> - Show quoted text -
What we were trying to do is have a client (via a browser app) get the
data from a data server, then pass a report name and the data to a
report server. I want to do this via a web service from report server
and then call a url but that requires passing data across applications
in IIS. I was hoping that the web services in the reporting servcies
could somehow help me. I don't know the right questions to ask to
resolve this.
Thanks.|||RS is designed as a SOA (Service Oriented Architecture). The pattern it is
designed to follow is that you give RS the parameters and the report name
and it does the rest. It queries the data and then renders it in whatever
format you desire. There is no direct way to do what you are asking for. If
you absolutely must do this you have several options:
1. Use the control that ships with VS 2005. It has a local and a remote
mode. In local mode you give the control the report and the tableset and it
does the rest. No server is used at all. However, there is a lot more work
to do with this method. You have to write code responding to events (for
instance with subreports). Designing a report is more complicated and takes
longer. And you lose the benefits of having a server (caching, performance
under load, subscriptions, etc).
2. If your goal is to interact with your own object model and the object
model retrieves the data then you might consider a Data Processing Extension
(search on that term in Books Online).
3. RS does have the ability to have a report be based on data returned by a
web service. So if the data you want to report off of is only available as a
web service this is a possibility for you.
http://technet.microsoft.com/en-us/library/ms345334.aspx
Finally, my guess is you have not created any reports in RS at all. That
would be a good place to start. Make sure you understand how to create
regular simple reports first and then go from there.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ross" <ross_smith@.csaa.com> wrote in message
news:5228a703-5767-4940-a3bc-b06e38f2c7ca@.i29g2000prf.googlegroups.com...
Snip
What we were trying to do is have a client (via a browser app) get the
data from a data server, then pass a report name and the data to a
report server. I want to do this via a web service from report server
and then call a url but that requires passing data across applications
in IIS. I was hoping that the web services in the reporting servcies
could somehow help me. I don't know the right questions to ask to
resolve this.
Thanks.