When using an Excel template can you have multipule FOCEXCs update different sheets (tabs) in a spreadsheet or does it need to be in a compound FOCEXC when running from report caster? Does the file on the reporting server actually have data written to it or does it just serve as the template? I need to know what to distribute.

Thanks

In theory, yes you can, but you will have to be careful about the order that they are run in and the storage of the interim archive files.

I achieve a similar process but within a single fex. My Client had a requirement where a variable number of sheets needs to be added to a template with the resulting file saved as a .xls.

I achieved this by having a set number of sheets maximum (I tried to add sheets to the archive via VBA but failed miserably - manually was OK but not programatically ). The maximum number should be more than they will ever need for this process (but I will be proved wrong in years to come ).

I use a dialogue manager loop to build an array of the variables for the selection statements and then INCLUDE the fex process. I set a variable filename of &filename.mht for each of the processes up until the last process where the extension becomes .xls instead of .xht. The variable filename is used in a FILEDEF immediately before the report process.

You could do a similar process but storing your interim .xht files in an APPS folder on your iWay server so that each subsequent .fex can access it as each .fex execution could use a different agent (and therefore different EDATEMP folder). I would also urge you to build a clean-up process into your overall schedule that deletes all the interim .xht files.

It could take a bit of planning and creating a flow chart may help you - combined with a descriptive document, it could also serve as future support documentation for you or your colleagues.

Good luck

T