Focal Point
[CLOSED] Open two excel workbooks when report is ran??

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4297068626

December 05, 2012, 12:02 PM
prodrigu
[CLOSED] Open two excel workbooks when report is ran??
Is it possible to have a procedure to open two excel workbooks? The first workbook would be report 1 and the second would be report 2. I know its possible to put the reports on different tabs but I want to be able to run my fex file and have report 1 open in a workbook and report 2 to open in a workbook.

Please let me know.

Thanks,
prodrigu

This message has been edited. Last edited by: Kerry,


Prod: WebFOCUS 7.7.03: Win 2008 & AIX hub/Servlet Mode; sub: AS/400 JDE; mostly Self Serve; DBs: Oracle, JDE, SQLServer; various output formats
December 10, 2012, 05:02 PM
Kerry
Hi prodrigu,

From our technicals: Viewing multiple Excel reports has been available since WebFOCUS 5.3 but requires changes to the mime.wfs file.

For other techniques please first search The forum where this has been asked several times and also search on the word compound.

If this doesn’t help, please open a case with Customer Support Services. You may call 1-800-736-6130, or access online at InfoResponse.

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
December 13, 2012, 11:29 AM
Kerry
Hi prodrigu,

Additional info from our product manager: Each procedure returns a single report / workbook. The client can only return a single output document / workbook at a time. Separate workbooks can be generated in a single procedure by holding each output to disk using HOLD but a WebFOCUS procedure can only generate and open a single workbook at a time directly in the Excel application using PCHOLD.


Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.