Dataset order in SQL Server Reporting Services
-
Hi, I really don`t know whether it`s the right place to post this question. I am using SSRS 2008 and I have a report which has two datasets among which one is a query and other is a stored procedure. The stored procedure is basically used to prepare data and insert it in a physical table from where the other dataset would query and generate the report. My problem is how do i configure the execution of the report so that the procedure executes first and the query executes after the completion of the execution of the stored procedure ? Any help would be appreciated.
When you fail to plan, you are planning to fail.
-
Hi, I really don`t know whether it`s the right place to post this question. I am using SSRS 2008 and I have a report which has two datasets among which one is a query and other is a stored procedure. The stored procedure is basically used to prepare data and insert it in a physical table from where the other dataset would query and generate the report. My problem is how do i configure the execution of the report so that the procedure executes first and the query executes after the completion of the execution of the stored procedure ? Any help would be appreciated.
When you fail to plan, you are planning to fail.
www.Developerof.NET wrote:
My problem is how do i configure the execution of the report so that the procedure executes first and the query executes after the completion of the execution of the stored procedure ?
Keep only one dataset - Stored Procedure one. In your SP, apart from preparing data and inserting it in a table, have a select query (which actually right now is in other dataset of yours). Select query result of the SP would return the needed data. Use it!