Execution Order of Multiple Data Sets

Hello, I have a report with multiple data sets. I would like to take the
subset of the results from one data set and use it in another but I am
wondering about timing issues. Are the data sets all executed simultaniously
or are they done in a specific order (ie. the order the data sets were
created)? Can the order be changed?Currently they execute in the order they are found in the RDL. Look at the
RDL (it is an xml file). Make a copy of the report first just in case but
you can modify the rdl directly and change the order.
I don't know if this is changing in RS 2005 but it is how it works in RS
2000.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:05406B56-54CF-4985-9132-AB85BD16E792@.microsoft.com...
> Hello, I have a report with multiple data sets. I would like to take the
> subset of the results from one data set and use it in another but I am
> wondering about timing issues. Are the data sets all executed
> simultaniously
> or are they done in a specific order (ie. the order the data sets were
> created)? Can the order be changed?|||Note: data sets are only executed in a certain order if they share the same
data source and you have "use transactions" turned on for the data source.
Otherwise, data sets are usually executed in parallel.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:Oj5G5AWmFHA.576@.TK2MSFTNGP15.phx.gbl...
> Currently they execute in the order they are found in the RDL. Look at the
> RDL (it is an xml file). Make a copy of the report first just in case but
> you can modify the rdl directly and change the order.
> I don't know if this is changing in RS 2005 but it is how it works in RS
> 2000.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:05406B56-54CF-4985-9132-AB85BD16E792@.microsoft.com...
>> Hello, I have a report with multiple data sets. I would like to take
>> the
>> subset of the results from one data set and use it in another but I am
>> wondering about timing issues. Are the data sets all executed
>> simultaniously
>> or are they done in a specific order (ie. the order the data sets were
>> created)? Can the order be changed?
>