Focal Point
Getting astrix in the count column

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7261025981

October 06, 2006, 12:58 PM
Adolf Mergulhao
Getting astrix in the count column
I run a simple report.
TABLE FILE CEW_KANA_DATA
SUM CNT.CASE_ID
BY CONTACT_METHOD1

Getting the following
CONTACT_METHOD1 CASE_ID
COUNT

EMAIL *****
WEBFORM *****

FIELDNAME=CASE_ID, ALIAS=CASE_ID, USAGE=I11, ACTUAL=I4, $

FIELDNAME=CONTACT_METHOD1, ALIAS=CONTACT_METHOD, USAGE=A25, ACTUAL=A25V,
MISSING=ON, $

Any ideas I tried to define the CASE_ID to a larger value but to no avail

Any assistance would be welcomed


Webfocus 7.6.2 on Windows Enterprise 2003 Server and
Webfocus 7.6.2 on HP Unix Server
October 06, 2006, 01:41 PM
Tony A
Adolf,

Use inline reformatting -

TABLE FILE CEW_KANA_DATA
SUM CNT.CASE_ID/D20.0
BY CONTACT_METHOD1

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
October 06, 2006, 01:45 PM
Adolf Mergulhao
Getting the following error

0 ERROR AT OR NEAR LINE 23 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC950) INVALID REFORMAT OPTION WITH COUNT OR CNT. : CNT.CASE_ID/D20.0
BYPASSING TO END OF COMMAND
(FOC009) INCOMPLETE REQUEST STATEMENT

TABLE FILE CEW_KANA_DATA
-* Generated by Report Assist
SUM CNT.CASE_ID/D20.0
BY CONTACT_METHOD1
ON TABLE SET PAGE-NUM OFF
ON TABLE SET STYLE DEFLT
END


Webfocus 7.6.2 on Windows Enterprise 2003 Server and
Webfocus 7.6.2 on HP Unix Server
October 06, 2006, 01:47 PM
Adolf Mergulhao
It works with the I10 format option.

Thanks


Webfocus 7.6.2 on Windows Enterprise 2003 Server and
Webfocus 7.6.2 on HP Unix Server
October 06, 2006, 03:02 PM
mgrackin
adolf,

You can also SET COUNTWIDTH = ON


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
October 10, 2006, 10:37 AM
Francis Mariani
Syntax: How to Set the Precision for COUNT and LIST
SET COUNTWIDTH = {OFF|ON}where:

OFF

Displays five characters (bytes) for COUNT and LIST counter values. Asterisks are displayed if the number of records retrieved for a field exceeds five characters. OFF is the default.


ON

Displays up to nine characters (bytes) for COUNT and LIST counter values. Asterisks are displayed if the value exceeds nine characters.


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