I've Created an HTML page with 5 .fex files in 5 IFRAMEs and a Radio Button to select the output format (HTML, XLSX, or CSV) as below, but when I select Excel as output only the .fex file that is listed first under Tasks & Animation, Requests/Actions is produced, the other 4 don't seem to run....works fine when I chose HTML or CSV

ON TABLE PCHOLD FORMAT &WFFMT.(,,).


Using App Studio's HTML composer

This message has been edited. Last edited by: RC@WB,

To include more than one report in Excel you need to use the COMPOUND feature, the BYTOC feature, the OPEN NOBREAK / CLOSE technique or an Excel template depending on the Excel version used.

Otherwise Excel will only include the first report.

Thanks Martin

quote:

I've Created an HTML page with 5 .fex files in 5 IFRAMEs and a Radio Button to select the output format

You can't have a HTML page with more than one report (5 IFrame) where all the 5 frames will be exported in one Excel in a easy way.

What I think you should do is to have a special process when Excel is selected where you will build your Excel report using one of the previous suggestion.
In other words you will have a fex that will process/call the 5 reports and build an Excel using either BYTOC/COMPOUND, OPEN NOBREAK/CLOSE, Excel template... I can't tell exactly which way you will need.
It will depend on data source, included data, relation between "reports", ... I don't have all the requirements and your data knowledge.

I understand, that makes sense. Great help Martin, thanks again

Edit your first post then in the subject at the beginning add [SOLVED]