Multiple Reports Execution

[ccc_ccc]

Hi All

I have 7 reports created from 7 different ODS's, now if i run first report the remaining 6 reports should execute automatically.

Condiotions.

1 The values entered by the user in selection screen that values should be restricted by 7 reports

Advantages

1 selection screen common for all 7 reports

let me know anu solutions.

By

ANR

[Former Member]

Hi ANR,

Create a workbook by using the 7 queries/reports of 7 ods's with same selection screen. once you refresh/execute the workbook and you will get final report.

Regs,

Vachan

[Former Member]

Hi ANR ,

You can attach all your 7 queries in different

sheets of the work book . I think you will have to do some VB coding so that when u execute 1st report remaining 6 reports also get executed.

Regards,

Prakash B

[former_member184494]

ANR ,

Have a web template with all the queries , there will be a single variable entry and all queries will take the same and run , it could also be explored using a Workbook.

Arun

Assigning points is a way of saying thank you in SDN

[ccc_ccc]

i assigned points for your valuable answer

thanks

anr

[Former Member]

Do not forget to set the query characteristics to automatically refresh the query when you open the workbook (if that is desired). You can also manually refresh all queries simultaneously by not selecting any of them and pressing refresh on the workbook containing them.