I'm new to reporting services and have a problem that I need help with.
Is there a way to set Dataset priority?
My problem is this. I have two datasets on my report that produce data
to display.
Dataset1(DS1) is a Stored procedure that returns a recordset.
DS2 is also a procedure that returns data.
DS1 creates a detailed set of records for a specific entity. While
doing this it runs 10-20 views and Procs (based on User Settings). In
order for DS2 to be correct, DS1 needs to be completely done before
the call to DS2 is made.
When running the report with SQL Profiler, I see that DS1 before DS2,
but DS2 is completing sooner.
Creating a LINKED sub-report for DS2 is not a viable alternative.
Any help would be greatly appreciated.
RUMAGEtry this:
create a parameter for the second SP, then setup the value of this parameter
from the SP1 result.
RS will evaluate the first SP, then execute to the second SP because there
is a parameter dependency.
"jrumage" <jeff@.grinandgiggle.com> wrote in message
news:1137429946.779314.249040@.g14g2000cwa.googlegroups.com...
> I'm new to reporting services and have a problem that I need help with.
> Is there a way to set Dataset priority?
> My problem is this. I have two datasets on my report that produce data
> to display.
> Dataset1(DS1) is a Stored procedure that returns a recordset.
> DS2 is also a procedure that returns data.
> DS1 creates a detailed set of records for a specific entity. While
> doing this it runs 10-20 views and Procs (based on User Settings). In
> order for DS2 to be correct, DS1 needs to be completely done before
> the call to DS2 is made.
> When running the report with SQL Profiler, I see that DS1 before DS2,
> but DS2 is completing sooner.
> Creating a LINKED sub-report for DS2 is not a viable alternative.
> Any help would be greatly appreciated.
> RUMAGE
>|||Thats a good idea, however it doesn't work the way you might thinkI
Doing that causes the first proc(DS1) to run twice.
First DS1 runs to get the result for the Parameter,
Then DS2 Runs,
Then DS1 runs to get the results for the report
Any Other ideas?|||For RS 2000 (and I believe RS 2005) the datasets get filled in the order
they are in the rdl file. Make a copy of your report (because messing with
the rdl file directly is dangerous) and move the definitions around.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"jrumage" <jeff@.grinandgiggle.com> wrote in message
news:1137517745.147303.157840@.g43g2000cwa.googlegroups.com...
> Thats a good idea, however it doesn't work the way you might thinkI
> Doing that causes the first proc(DS1) to run twice.
> First DS1 runs to get the result for the Parameter,
> Then DS2 Runs,
> Then DS1 runs to get the results for the report
> Any Other ideas?
>