Hi,
I would like to execute in order same queries that I used in a reports. First of all I would like to execute an stored procedure that change my date in the database, after the stored procedured is executed correctly I want rest of queries run, and finally when all of these queries run with the data changed, I would like to execute another procedure to change the data to actual date.
Has anyone any idea how I can do that?
Quote from: erjorgea on 11 Jun 2019 04:37:19 AM
Hi,
I would like to execute in order same queries that I used in a reports. First of all I would like to execute an stored procedure that change my date in the database, after the stored procedured is executed correctly I want rest of queries run, and finally when all of these queries run with the data changed, I would like to execute another procedure to change the data to actual date.
Has anyone any idea how I can do that?
This sounds to me like something you'd need to use Event Studio for?
Cheers!
MF.
Thanx, I did not know Event Studio exists, after trying multiple attemps, finally I can change the date before running the report, and then after send the report in email I change again the date to actual date.
Thx for your support