[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, prodriguThis message has been edited. Last edited by: Kerry,
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.