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     Help Populating Multiple Excel Spreadsheet Tabs

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Help Populating Multiple Excel Spreadsheet Tabs
 Login/Join
 
k8iw
Member
posted
Hello,

I am on a team trying to create reports on multiple tabs in one template Excel spreadsheet. The data comes from multiple, joined Oracle tables. One tab is to contain a summary of the data on three other tabs. Does someone have an example of the code to populate an Excel spreadsheet with multiple tabs? Or can you just show the code to produce data on several tabs? I have not worked with the latest versions of WF that have this capability.

Thank you once again for the great help on this forum.

Mike Anderson
Nationwide Insurance
Columbus, Ohio


Mike Anderson
 
Posts: 14 | Location: Columbus, Ohio | Registered: May 20, 2003Report This Post
Leah
Virtuoso
posted Hide Post
You can create a compound report in excel, use style sheet commands to change the titletext for each Tab. Don't have an example immediately handy but if someone doesn't beat me to it may post one later. My day is filled with an on-line demo from a software company for our student system conversion, so not much in the coding mode at the moment.


Leah
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
Anatess
Guru
posted Hide Post
you can do multiple tab excel by using compound reports. 
-SET COMPOUND=ON
TABLE FILE <oracle table>
<summary report here>
ON TABLE PCHOLD FORMAT EXL2K OPEN
END
-RUN
TABLE FILE <oracle table>
<detail report on 2nd tab here>
ON TABLE PCHOLD FORMAT EXL2K
END
-RUN
...ETC
last TABLE FILE you do FORMAT EXL2K CLOSE
then -SET COMPOUND=OFF to turn off compound reporting


You can assign tab titles using TITLETEXT paramet on your CSS.

Hope this helps. Sorry, it doesn't touch on templates...


WF 8.1.05 Windows
 
Posts: 333 | Location: Orlando, FL | Registered: October 17, 2006Report This Post
Leah
Virtuoso
posted Hide Post
One caveat to Anatess, there is no dash before the SET command. that is SET COMPOUND=OPEN
AND SET COMPOUND=CLOSE


Leah
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
PBrightwell
Master
posted Hide Post
Do a search on Excel Templates, there has been a lot of discussion lately.


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
 
Posts: 755 | Location: TX | Registered: September 25, 2007Report This Post
<Shyam L>
posted
Compound reports with OPEN and CLOSE clauses doesnt work with Excel Templates.
Mike, you can use this sample code as referance:

APP FI HLD_FIL_NM DISK tmplt1.mht
-INCLUDE your_fex_1.fex
ON TABLE HOLD AS HLD_FIL_NM FORMAT EXL2K TEMPLATE 'original_template_name' SHEETNUMBER 1
END
-RUN

-INCLUDE your_fex_2.fex
ON TABLE PCHOLD FORMAT EXL2K TEMPLATE 'tmplt1' SHEETNUMBER 2
END
-RUN

You can repeat this sequence for how many reports you need.
 
Report This Post
linus
Platinum Member
posted Hide Post
You can also use the 'BYTOC' command. This will give you tabs/worksheets on your highest sort field.


WF 7.7.05
HP-UX - Reporting Server, Windows 2008 - Client, MSSQL 2008, FOCUS Databases, Flat Files
HTML, Excel, PDF
 
Posts: 149 | Location: Dallas, TX | Registered: June 08, 2007Report This Post
k8iw
Member
posted Hide Post
Hello,

I just want to thank each of you for taking the time to respond to my request. I passed this along to the developers. If we run into snags I will start a new thread. But just know you guys are just great!

Mike Anderson
Nationwide Insurance
Columbus, OH


Mike Anderson
 
Posts: 14 | Location: Columbus, Ohio | Registered: May 20, 2003Report 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     Help Populating Multiple Excel Spreadsheet Tabs

Copyright © 1996-2020 Information Builders