October 06, 2006, 12:58 PM
Adolf MergulhaoGetting 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
October 06, 2006, 01:41 PM
Tony AAdolf,
Use inline reformatting -
TABLE FILE CEW_KANA_DATA
SUM CNT.CASE_ID/D20.0
BY CONTACT_METHOD1
T
October 06, 2006, 01:45 PM
Adolf MergulhaoGetting 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
October 06, 2006, 01:47 PM
Adolf MergulhaoIt works with the I10 format option.
Thanks
October 06, 2006, 03:02 PM
mgrackinadolf,
You can also SET COUNTWIDTH = ON
October 10, 2006, 10:37 AM
Francis MarianiSyntax: 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