Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Open two excel workbooks when report is ran??

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Open two excel workbooks when report is ran??
 Login/Join
 
Platinum Member
posted
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
 
Posts: 121 | Location: California | Registered: June 19, 2008Report This Post
Expert
posted Hide Post
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.
 
Posts: 1948 | Location: New York | Registered: November 16, 2004Report This Post
Expert
posted Hide Post
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.
 
Posts: 1948 | Location: New York | Registered: November 16, 2004Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Open two excel workbooks when report is ran??

Copyright © 1996-2020 Information Builders