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] Issue in Loading fields in Subhead!
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Issue in Loading fields in Subhead!
 Login/Join
 
Gold member
posted
Hi,

I have scenario to load more than 300 dynamic columns in SUBHEAD using EXL2K.

Now it is not showing more than 121 columns! is there any limitation in 8105? Are we have solution on this.

Please share...

Sample:
  
TABLE FILE CAR
BY CAR
ON CAR SUBHEAD
"Mine<+0>PMT<+0>Schedule <+0> Priority <+0>Parti<+0>Part<+0>*** Plt<+0>Com<+0>  Site<+0>Code<+0>Sup<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>FeRa<+0>FeAs<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>FeRa<+0>FeAs<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>Help Needed<+0>Deliverable Conformance Plan<+0>"
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=SUBHEAD,HEADALIGN=BODY, FONT='ARIAL',SIZE=10,STYLE=BOLD,JUSTIFY =LEFT,BORDER=0.3,BACKCOLOR=RGB(238 236 225),WRAP=ON,$
ENDSTYLE
END




Thanks,
Dev

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


8202, 8105M, 7.7.03
 
Posts: 78 | Registered: June 12, 2012Reply With QuoteReport This Post
Virtuoso
posted Hide Post
There used to be 6500 character Limit in Subheads and Subfoots. Not sure what it is in version 8.
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Reply With QuoteReport This Post
Gold member
posted Hide Post
Using less than 6500 Character Frowner

Right now it will allow 126 Columns (in excel)


8202, 8105M, 7.7.03
 
Posts: 78 | Registered: June 12, 2012Reply With QuoteReport This Post
Expert
posted Hide Post
My guess is that you need to break the HEADING text into multiple lines:

TABLE FILE CAR
BY CAR
ON CAR SUBHEAD
"Mine<+0>PMT<+0>Schedule <+0> Priority <+0>Parti<+0>Part<+0>*** Plt<+0>Com<+0>Site<0X
<+0>Code<+0>Sup<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<0X
<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>FeRa<+0>FeAs<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<0X
<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<0X
<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<0X
<+0>FeRa<+0>FeAs<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<0X
<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<0X
<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<0X
<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<+0>DR<+0>Gre<+0>Cda<+0>Mil<0X
<+0>Help Needed<+0>Deliverable Conformance Plan<+0>"
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=SUBHEAD,HEADALIGN=BODY, FONT='ARIAL',SIZE=10,STYLE=BOLD,JUSTIFY =LEFT,BORDER=0.3,BACKCOLOR=RGB(238 236 225),WRAP=ON,$
ENDSTYLE
END


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
Warning! We are one post away from F10K (Francis Mariani 10,000 posts)! The end is nigh!


App Studio
WebFOCUS 8.1.05M
Windows, All Outputs
 
Posts: 594 | Location: Michigan | Registered: September 04, 2015Reply With QuoteReport This Post
Gold member
posted Hide Post
quote:
Francis Mariani


Tried. Giving the same result.


8202, 8105M, 7.7.03
 
Posts: 78 | Registered: June 12, 2012Reply With QuoteReport This Post
Expert
posted Hide Post
are you holding in exl2k for a reason? and not exl07 ? or xlsx ?




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Reply With QuoteReport This Post
Gold member
posted Hide Post
The above concept is not working in HTML and Excel (2k & 07) versions.


8202, 8105M, 7.7.03
 
Posts: 78 | Registered: June 12, 2012Reply With QuoteReport This Post
Virtuoso
posted Hide Post
I found this on the Tech Site

Problem:
Is there a limit to the number of bytes that can be placed in a HEADING,
FOOTING, SUBHEAD or SUBFOOT?

Solution:
The maximum for heading/footing/etc is 32K bytes. This is true for
WebFOCUS 7.1x and 7.6x and for Mainframe FOCUS 7.6x.
incorrect.
The number of characters actually obtained is also dependent on the
amount of memory the c program can get when the procedure is run, so the
limit of 32K may not be available when the procedure is run.

A single line in the heading can have a maximum of 410 characters.
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Reply With QuoteReport This Post
Member
posted Hide Post
Does it run correctly when you run a non-Excel format? Have you tried newer Excel output types?


WebFOCUS 8.1.0.5m
 
Posts: 26 | Registered: October 09, 2007Reply With QuoteReport This Post
Gold member
posted Hide Post
It is not working in xlsx also.


8202, 8105M, 7.7.03
 
Posts: 78 | Registered: June 12, 2012Reply With QuoteReport This Post
Guru
posted Hide Post
Dev,
The example provided by Francis produced an Excel report for me in WebFOCUS 8105 in both formats XLSX and EXL2K

Office 2013 was used. What MS Office are you running?

Here are the limitations found in the WebFOCUS 8105 Reporting Language documentation:
EXCEL:
FORMAT XLSX
Description: Generates fully styled reports in Excel 2007 XML format. You must have Excel 2007
or higher installed to use this output format.
An Excel 2007 worksheet can contain 1,048,576 rows by 16,384 columns. WebFOCUS will
generate worksheets larger than these defined limits, but Excel 2007 will have difficulty opening
the resulting workbook, and the data that exceeds the Excel 2007 limits will be truncated.

FORMAT EXL2K
Description: Generates fully styled reports in Excel 2000 HTML format. You must have Excel
2000 installed to use this output format.
ACROSS column titles are supported for EXL2K output format.
For EXL2K output format, a report can include 65,536 rows and/or 256 columns. Rows and
columns in excess of these limits are truncated from the worksheet when opened in Excel.

For information about creating overflow worksheets for the additional rows when the number of
rows becomes too high for a single worksheet, see Overcoming the Excel 2003 65K Row Limit
Using Overflow Worksheets on page 672.


Creating Reports With WebFOCUS Language Release 8.1 Version 05M (DN4501483.1216)

You will be required to logon to the Technical Support Center to view the above documentation.


Thank your for participating in the Focal Point Forum,

Tamra Colangelo
Focal Point Moderator
Information Builders


WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
 
Posts: 487 | Location: Toronto | Registered: June 23, 2009Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Issue in Loading fields in Subhead!

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