RS communication with SQL Server

Hallo,
I have a question about the communications between Reporting Server
and SQL server works, when using the drill down funtion:
Does the RS requests all the data from the SQL Server at the first
time the client opens the report (not expanded in the first step), or
not?
If the user does a drill down now, how does it work in the backend:
a.) client - RS - client [a lot of data allready stored in RS]
b.) client - RS - SQL Server - RS - Client [every request from the
user needs a communication between RS and SQL Server]
Thanks for your help!
Best regards,
DietmarDietmar,
RS doesn't download the whole report to the client for reports with
interactive features (drilldown, toggled visibility, document maps), neither
it does for multi-page HTML reports. Instead, when the user expands a
section (or navigates to another page) a subsequent HTTP-GET request is
fired. Hence, report with interactive features require URL access.
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"Dietmar B" <dietmar.boeckmann@.aon.at> wrote in message
news:4f2062b1.0409240509.7feb9078@.posting.google.com...
> Hallo,
> I have a question about the communications between Reporting Server
> and SQL server works, when using the drill down funtion:
> Does the RS requests all the data from the SQL Server at the first
> time the client opens the report (not expanded in the first step), or
> not?
> If the user does a drill down now, how does it work in the backend:
> a.) client - RS - client [a lot of data allready stored in RS]
> b.) client - RS - SQL Server - RS - Client [every request from the
> user needs a communication between RS and SQL Server]
> Thanks for your help!
> Best regards,
> Dietmar