Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Populating multiple Excel tabs in webfocus
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Populating multiple Excel tabs in webfocus
 Login/Join
 
Member
posted
Is there a limit as to the number of worksheets that could be populated with a webfocus report?

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


WebFOCUS 8105
Windows, Excel
 
Posts: 15 | Registered: November 03, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
PO

I am not aware of any limit, I assume you are using the Table of Contents option to force the creation of multiple tabs (worksheets).


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1633 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Guru
posted Hide Post
Note the number of worksheets is
limited by available memory on the user's machine.


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
 
Posts: 406 | Location: Europe | Registered: February 05, 2007Reply With QuoteReport This Post
Master
posted Hide Post
I have a job that creates over 100 worksheet in one workbook.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 934 | Location: Oklahoma City | Registered: October 27, 2006Reply With QuoteReport This Post
Member
posted Hide Post
quote:
Originally posted by jgelona:
I have a job that creates over 100 worksheet in one workbook.

Do you use only COMPOUND ON?


WebFOCUS 8105
Windows, Excel
 
Posts: 15 | Registered: November 03, 2017Reply With QuoteReport This Post
Member
posted Hide Post
No I am not using a table of content to create multiple tabs. Should I be using that?


WebFOCUS 8105
Windows, Excel
 
Posts: 15 | Registered: November 03, 2017Reply With QuoteReport This Post
Expert
posted Hide Post
PO, may I suggest you tell us what you're attempting to accomplish?

If WebFOCUS could create a spreadsheet with 5000 tabs, how does that help?


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Master
posted Hide Post
In my report the sheets are looping through the code. I have an & variable name &OPEN. On the first pass the value is OPEN. On the last pass the value is CLOSE. All the passes in between the value is blank.

ON TABLE PCHOLD FORMAT XLSX &OPEN

This is a summary report. The first pass is a state wide summary. The next 5 passes are Region Summaries. The rest of the passes are for each County.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 934 | Location: Oklahoma City | Registered: October 27, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Populating multiple Excel tabs in webfocus

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.