Friday, February 24, 2012

Communication between client and reportserver

I tried asking this earlier, but don't think that I did a decent job of
explaining the issue or asking the question. Here goes again:
Can anyone explain to me the differences between the ReportViewer web
control, URL Access, and Web Services with respect to reporting services?
1) Obviously, the web services access the report server directly
2) URL Access probably hits the report server directly.
3) The report viewer web control has a remote mode, but I'm not sure if the
rendering is performed on the web server prior to being sent down to the
client.
I'd like to keep all communication between the client and the web server and
avoid any direct communication between the client and the reporting server
which is running on a different machine inside the firewall. Web Services
work, but eliminate interactive sorting features.The answer is version dependent. RS 2000 report viewer control used URL
integration and had some issues. To get around this issues you could use web
services and create your own front end. With RS 2005 and the new controls
found in VS 2005, they use web services to integrate in with the server.
Rendering is done at the server UNLESS you are using local mode. Local mode
has some limitations and does not use a server at all. You have to give it
the report and the dataset.
If you are not on RS 2005 I highly recommend doing so. The new controls
offer much better and much easier integration with your application than was
possible under RS 2000.
URL integration is the easiest and sometimes only way but it is really not
suitable with firewalls. I use it for integration into an application that I
could put an IE control (it is not a dotnet app so the winform control would
not work).
Hope this helps,
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan Shookowsky" <DanShookowsky@.discussions.microsoft.com> wrote in message
news:2D598E3C-EC45-4B1E-9E9A-CEFE8CC7C855@.microsoft.com...
>I tried asking this earlier, but don't think that I did a decent job of
> explaining the issue or asking the question. Here goes again:
> Can anyone explain to me the differences between the ReportViewer web
> control, URL Access, and Web Services with respect to reporting services?
> 1) Obviously, the web services access the report server directly
> 2) URL Access probably hits the report server directly.
> 3) The report viewer web control has a remote mode, but I'm not sure if
> the
> rendering is performed on the web server prior to being sent down to the
> client.
> I'd like to keep all communication between the client and the web server
> and
> avoid any direct communication between the client and the reporting server
> which is running on a different machine inside the firewall. Web Services
> work, but eliminate interactive sorting features.

No comments:

Post a Comment