This is a strange requirement. We have a Webfocus 8104 application that pulls from Microsoft SQL Server.

On the server we have a master table that gets loaded by informatica. Files come into informatica through a network drive as pipe delimited files and are loaded. There are groups of reports based on the set of files.

To run the reports the user logs into the portal and selects a client from a dropdown. That looks at the database and pulls all of the rounds of data that client has along with the reports and different timestamps if there are any.They select excel or html which looks at a stub procedure that has either a ahtml fex or excel fex. Then it runs the report.

The issue we're trying to solve is if a user selects a client and a round of data to export all of the fex files as a single excel file. So in essence looking at the client and road and then outputting all of xlsx fexs in one report.

Has anyone done something like this, I know its odd but wanting to check. If not what suggestions would you have to making this work.

I've thought about caster but wasn't sure. Also thought of dynamically populating a list box with of the available reports and then a button to run them.

Thank you for any help in advance

Warren

This message has been edited. Last edited by: FP Mod Chuck,

All fex write extracted data into one common data file with specific id then :
- use Excel BYTOC feature based on the id
- use OPEN and CLOSE feature using data id
- use an Excel template where each data id will reference its own Excel sheet (SHEETNUMBER x)

All fex write its own data file then another fex read those files to produce the final report with any of above options

And many more options combining different technic