Round Trips on Drill Down

Can anyone confirm what's happening when a user click the drill down (+)
button to expand or collapse data.
It appears to be doing a round trip, but does not appear to be re-querying
the data. The round trip process is too fast.
I am using OnDemand reports (no cache or snapshot), and the theory says the
OnDemand dataset is only available for the initial rendering.
Is IIS, .net or RS caching the dataset for the expand process to work.
Does anyone have any good doco on what happens where?
Thanks
JasonI can't give you a good document on what is happening, however I can tell
you that it IS making a round trip.
I have a report with sub-reports, the sub-reports are hidden initially. The
user SHOULD click the + and the div tag that hids the sub report would
change status from invisible to visible. That's not what happens.
I know this because I use SOAP to render my reports from a web-server, not
the SQL server. When the user clicks the + it tries to take them to the SQL
server, not back to my site with my code that launched the thing in the
first place. (RATS!)
"Jason Buck" <jason@.REMOVE_THE_CAPScustombizsolutions.com> wrote in message
news:u9hseEVdEHA.3308@.TK2MSFTNGP11.phx.gbl...
> Can anyone confirm what's happening when a user click the drill down (+)
> button to expand or collapse data.
> It appears to be doing a round trip, but does not appear to be re-querying
> the data. The round trip process is too fast.
> I am using OnDemand reports (no cache or snapshot), and the theory says
the
> OnDemand dataset is only available for the initial rendering.
> Is IIS, .net or RS caching the dataset for the expand process to work.
> Does anyone have any good doco on what happens where?
> Thanks
> Jason
>|||Drilldown would indeed cause a post back to the report server but not a new
report execution. On the initial report execution, the report server creates
a session for you and stores a copy of the data in it. Further navigation in
that report, as well as images, drill-downs will work off that session.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jason Buck" <jason@.REMOVE_THE_CAPScustombizsolutions.com> wrote in message
news:u9hseEVdEHA.3308@.TK2MSFTNGP11.phx.gbl...
> Can anyone confirm what's happening when a user click the drill down (+)
> button to expand or collapse data.
> It appears to be doing a round trip, but does not appear to be re-querying
> the data. The round trip process is too fast.
> I am using OnDemand reports (no cache or snapshot), and the theory says
the
> OnDemand dataset is only available for the initial rendering.
> Is IIS, .net or RS caching the dataset for the expand process to work.
> Does anyone have any good doco on what happens where?
> Thanks
> Jason
>|||Thanks,
So is this correct.
1. I view an ondemand report, and it creates the Int. Rep (the data) in the
session variable.
2. This data is marked as available only to my session, with some indicator
that it was for this 'run' of the report
3. When I drill down, it re-renders using the data from above.
4. I hit the refresh button on the report, so (being ondemand) it
regenerates the data and creates a new item in the session object for this
run of the report.
5. Now I have 2 Int Reps, in the 1 session object, and the session object
is not going to be destroy until session timeout.
do the individual data sets get destroyed earlier at some time? Where do I
configure this and the session timeout?
thanks
Jason
"Tudor Trufinescu (MSFT)" <tudortr@.ms.com> wrote in message
news:ut4scTddEHA.2696@.TK2MSFTNGP09.phx.gbl...
> Drilldown would indeed cause a post back to the report server but not a
new
> report execution. On the initial report execution, the report server
creates
> a session for you and stores a copy of the data in it. Further navigation
in
> that report, as well as images, drill-downs will work off that session.
> --
> Tudor Trufinescu
> Dev Lead
> Sql Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Jason Buck" <jason@.REMOVE_THE_CAPScustombizsolutions.com> wrote in
message
> news:u9hseEVdEHA.3308@.TK2MSFTNGP11.phx.gbl...
> > Can anyone confirm what's happening when a user click the drill down (+)
> > button to expand or collapse data.
> >
> > It appears to be doing a round trip, but does not appear to be
re-querying
> > the data. The round trip process is too fast.
> >
> > I am using OnDemand reports (no cache or snapshot), and the theory says
> the
> > OnDemand dataset is only available for the initial rendering.
> >
> > Is IIS, .net or RS caching the dataset for the expand process to work.
> >
> > Does anyone have any good doco on what happens where?
> >
> > Thanks
> >
> > Jason
> >
> >
>