Execute queries in order

[erjorgea]

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?

[MFGF]

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.

[erjorgea]

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