Hi All,

Here is one of my scenario.

I have 15 seperate FEX files, each will genearte a single compound Excel report. I need to create a single schedule, that runs all these FEXes and create 15 seperate excel files and put it in the report library or send it in Mail. Is there a way to do this ?

I can do an -INCLUDE of 15 files in a Single FEX and schedule that, But will that genearate 15 seprate Excel files for me ?

Depending on your Report Caster Configuration setting "PACKET EMAIL" (needs to be Yes), all the different excel files should be in the same email. That is if you put in a separate task for each one of the reports.
If you want one file or smaller email attachments, can you use the ZIP output option (last tab on Report Caster Schedule)?
If you -INCLUDE them all in one fex, only the last one will be distributed.

Thank you Selph. Will try this and let you know on this.

Hi Selph,

But how in case of putting output to Report Library... Are there options for this as well.?

I am not familiar with the capabilities of Report Library. Hopefully someone else will answer.

Thank you Selph...

Could someone else throw some light in this area ? How this is achievable or whether this achievable with Report Library ?


Any help would be appreciated!

Thanks.

In the ReportCaster scheduling tool, for a single schedule add different tasks for each FEX files.

So you have to create 15 tasks for 15 FEX files and all the results will be sent in mail with 15 separate EXCEL files once scheduled.