All geek questions in one place

How to change query execution order in SSRS?

How can I control which stored proc is launched first in SSRS. My second saved proc should use the temp table data from the first saved proc. Many thanks.

+3
source share
3 answers

What you offer is a bad idea. If both datasets share a table, you can combine them into one result set, then filter or aggregate it in the report.

However, you tried reordering the datasets in the RDL (XML) file. I believe the report service will run them in order, although it can run them asynchronously. No warranties.

EDIT:

Adolf , , . RDL, .

+3

If you use the value from the first data set of the procedure that will be used to populate the input parameter used by the second procedure, this should ensure that they are called in the desired order.

However, I agree with jimconstable - it would be wiser to use a single dataset and filter out any unwanted results.

0
source

Source: https://habr.com/ru/post/1763662/

More articles:


All Articles