I have a piece of code here that uses an actual Sql query developed in a Rdbms and then used in the WebFocus code. The problem is I cannot get the subtotal for each card type to show unless I also show the item_count column as well. Is there a way I can show the subtotal for each card without the item_count showing? Thanks.
SET NODATA = ' '
SET SQLENGINE=SQLORA
SQL SET SERVER DWD_DLHCM
SQL
SELECT DISTINCT
cf.card_type_code
,sr.reason_code
,oi.card_dcn
,oi.oi_identifier
,oi.create_date
,oi.oi_dl
,oi.item_count
FROM
DWDH_OWNER.DWDHF_ORDER_ITEM oi
,DWDH_OWNER.DWDHF_CARD_STOCK cs
,(SELECT * FROM DWDH_OWNER.DWDHD_STATUS_REASON WHERE CUR_IND_FLG = 'Y') sr
,(SELECT * FROM DWDH_OWNER.DWDHD_CARDFILE_TYPE WHERE CUR_IND_FLG = 'Y') cf
,(SELECT * FROM DWGL_OWNER.DWGLD_COMPANY WHERE CUR_IND_FLG = 'Y') c
WHERE
cs.card_dcn = oi.card_dcn (+)
AND oi.dhd_status_reason_id = sr.id
AND oi.dhd_cardfile_type_id = cf.id
AND oi.gld_company_id = c.id
AND (sr.STATUS_CODE = 'PROD_F')
AND (sr.REASON_CODE IN ('CARD_DAMAGED', 'DATA_QUALITY', 'SIGNATURE_QUALITY', 'IMAGE_QUALITY', 'INC_DATA'))
AND TO_CHAR( oi.oi_EFFECTIVE_DT, 'YYYY-MM-DD') BETWEEN '2007-05-01' AND '2007-06-30'
;
TABLE ON TABLE HOLD AS DR2
END
TABLE FILE DR2
SUM
CARD_TYPE_CODE
REASON_CODE
CARD_DCN
OI_IDENTIFIER
CREATE_DATE
OI_DL
ITEM_COUNT
BY
CARD_TYPE_CODE NOPRINT
BY
CARD_DCN NOPRINT
BY
CREATE_DATE NOPRINT
ON CARD_TYPE_CODE SUBTOTAL AS 'TOTAL '
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE SET ONLINE-FMT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='SCREEN',
LEFTMARGIN=0.000000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.000000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
ENDSTYLE
END

quote:

ON CARD_TYPE_CODE SUBTOTAL AS 'TOTAL '

Just specify the numeric fields you want the total for. For example:

ON CARD_TYPE_CODE SUBTOTAL AS 'TOTAL ' card_type_code

Assuming that card_type_code is a numeric field then only this field will have a total.


Good luck

No, card_type_code is a character field.
I also tried item_count field which is numeric after the 'TOTAL' but it didn't work.

Documented syntax:

{BY|ON} fieldname {SUB-TOTAL|SUBTOTAL} [MULTILINES] [field1 [AND] field2...] [AS 'text'][WHEN expression;]

Example:

ON DELETEREASON SUBTOTAL SUSPENSIONNUMBER AS 'Total' 

I tried these lines of code:
ON CARD_TYPE_CODE SUBTOTAL
ITEM_COUNT AS 'TOTAL '
WHERE CARD_TYPE_CODE IN ('DLCARD_V1', 'HCARD_V1');
which gives exactly the same results as the first way I did it:
ON CARD_TYPE_CODE SUBTOTAL AS 'TOTAL '

The results are identical which look like this:
CARD_TYPE_CODE REASON_CODE CARD_DCN OI_IDENTIFIER CREATE_DATE OI_DL ITEM_COUNT
DLCARD_V1 CARD_DAMAGED DL0000001 release4orderitemidentifierdl1 2007/06/10 11:00:00 D1234-56789-00001 1
DLCARD_V1 CARD_DAMAGED DL0000002 release4orderitemidentifierdl2 2007/06/10 11:01:00 D1234-56789-00002 1
DLCARD_V1 CARD_DAMAGED DL0000003 release4orderitemidentifierdl3 2007/06/10 11:02:00 D1234-56789-00003 1
DLCARD_V1 CARD_DAMAGED DL0000004 release4orderitemidentifierdl10 2007/06/10 11:09:00 D1234-56789-00010 1
DLCARD_V1 CARD_DAMAGED DL0000005 release4orderitemidentifierdl14 2007/06/10 11:13:00 D1234-56789-00014 1
DLCARD_V1 CARD_DAMAGED DL0000006 release4orderitemidentifierdl15 2007/06/10 11:14:00 D1234-56789-00015 1
DLCARD_V1 CARD_DAMAGED DL0000007 release4orderitemidentifierdl20 2007/06/10 11:19:00 D1234-56789-00020 1
DLCARD_V1 CARD_DAMAGED DL0000008 release4orderitemidentifierdl27 2007/06/10 11:26:00 D1234-56789-00027 1
DLCARD_V1 CARD_DAMAGED DL0000009 release4orderitemidentifierdl28 2007/06/10 11:27:00 D1234-56789-00028 1
DLCARD_V1 CARD_DAMAGED DL0000010 release4orderitemidentifierdl44 2007/06/10 11:43:00 D1234-56789-00044 1
DLCARD_V1 IMAGE_QUALITY DL0001175 release4orderitemidentifierdl1180 2007/06/04 12:19:00 D1234-56789-01180 1
DLCARD_V1 SIGNATURE_QUALITY DL0001175 release4orderitemidentifierdl1180 2007/06/04 12:29:00 D1234-56789-01180 1
DLCARD_V1 IMAGE_QUALITY DL0001175 release4orderitemidentifierdl1180 2007/06/04 12:39:00 D1234-56789-01180 1
DLCARD_V1 IMAGE_QUALITY DL0001176 release4orderitemidentifierdl1181 2007/06/05 12:00:00 D1234-56789-01181 1
DLCARD_V1 SIGNATURE_QUALITY DL0001176 release4orderitemidentifierdl1181 2007/06/05 12:29:00 D1234-56789-01181 1
DLCARD_V1 IMAGE_QUALITY DL0001176 release4orderitemidentifierdl1181 2007/06/05 12:39:00 D1234-56789-01181 1
DLCARD_V1 IMAGE_QUALITY DL0001177 release4orderitemidentifierdl1182 2007/06/05 12:01:00 D1234-56789-01182 1
DLCARD_V1 IMAGE_QUALITY DL0001178 release4orderitemidentifierdl1183 2007/06/05 12:02:00 D1234-56789-01183 1
DLCARD_V1 CARD_DAMAGED DL0001179 release4orderitemidentifierdl1184 2007/06/05 13:13:00 D1234-56789-01184 1
DLCARD_V1 CARD_DAMAGED DL0001216 release4orderitemidentifierdl1184 2007/06/05 13:33:00 D1234-56789-01184 1
DLCARD_V1 CARD_DAMAGED DL0001217 release4orderitemidentifierdl1184 2007/06/05 13:53:00 D1234-56789-01184 1

TOTAL DLCARD_V1
21

HCARD_V1 CARD_DAMAGED HC0000001 release4orderitemidentifierhc10 2007/06/07 10:00:10 1
HCARD_V1 CARD_DAMAGED HC0000002 release4orderitemidentifierhc20 2007/06/07 10:00:20 1
HCARD_V1 CARD_DAMAGED HC0000003 release4orderitemidentifierhc30 2007/06/07 10:00:30 1
HCARD_V1 CARD_DAMAGED HC0000004 release4orderitemidentifierhc40 2007/06/07 10:00:40 1
HCARD_V1 CARD_DAMAGED HC0000005 release4orderitemidentifierhc50 2007/06/07 10:00:50 1

TOTAL HCARD_V1
5

If I suppress the last column I cannot get the totals.

Adrian,

You want to display the total number of ITEM_COUNT without display it in each line. This cannot be done with SUBTOTAL but with SUBFOOT and a multi-set request.

After TABLE FILE DR2 add:

SUM ITEM_COUNT NOPRINT
BY CARD_TYPE_CODE NOPRINT

and then in place of
ON CARD_TYPE_CODE SUBTOTAL AS 'TOTAL '
write

ON CARD_TYPE_CODE SUBFOOT
"<ST.ITEM_COUNT "

This should do the trick.

As Daniel mentions, you cannot SUTOTAL a field that is not a displayed report column - SUBFOOT is the method we use for that.

Or, alternatively, a multi-verb request *may* be acceptable, the subtotal is not on a line by itself, but as a report column:

TABLE FILE CAR
SUM
WHEELBASE AS 'Total Wheelbase'
BY COUNTRY
SUM
SALES
BY COUNTRY
BY CAR
END

The WHEELBASE column is SUMmed in the first verb and the SALES are SUMmed in the second.

The result would look like the following:

COUNTRY   Total Wheelbase CAR                  SALES 
--------- --------------- ------------ -------------
ENGLAND             407.8 JAGUAR               12000 
                          JENSEN                   0 
                          TRIUMPH                  0 
FRANCE              108.0 PEUGEOT                  0 
ITALY               384.4 ALFA ROMEO           30200 
                          MASERATI                 0 
JAPAN               185.4 DATSUN               43000 
                          TOYOTA               35030 
W GERMANY           721.7 AUDI                  7800 
                          BMW                   0390 

Thanks Danny, I got it to work the way you told me.
On a hunch, I tried TOT.ITEM_COUNT in the table FOOTING and then I got the grand total to show as well. Thanks very much.

Hello,
My old code worked fine when the output was all on one page. When it was on more than one page, it didn't work correctly so I had to make changes. The total card production failures was moved to a ON TABLE SUBFOOT line instead of a FOOTING line in the old code. However, the ON CARD_TYPE_CODE SUBFOOT line now shows ** for the first card type and a correct number for the second card type. The total card type line now shows ** as well.
Should I do another pass on the table before I can dipslay those numbers? I did a query on the hold file and has shown it in the code. The output is shown after the code. Thank you.

-SET &ECHO=ALL;
SET NODATA = ' '
SET PRINTPLUS = ON
-DEFAULT &FROM_DATE = '20070301';
-DEFAULT &TO_DATE = '20070331';
-DEFAULT &ADATE1 = '20070601';
-DEFAULT &ADATE2 = '20070630';
-DEFAULT &OUTPUT = 'HTML';
-*
-SET &REP_NAME = 'Detailed Card Production Failures Report';
-SET &RUN_DATE = &DATEMtrDYY;
-SET &RUN_TIME = EDIT(HHMMSS('A8'),'99$:99$:99');
-SET &ORIENTATION = 'LANDSCAPE';
-SET &ADATETIME1 = EDIT(&ADATE1,'9999-99-99')| ' 00:00:00';
-SET &ADATETIME2 = EDIT(&ADATE2,'9999-99-99')| ' 23:59:59';
-SET &ADATE1TEXT = LCWORD(17,CHGDAT('YYMD', 'MXDYY', &ADATE1, 'A17'), 'A17');
-SET &ADATE2TEXT = LCWORD(17,CHGDAT('YYMD', 'MXDYY', &ADATE2, 'A17'), 'A17');
-SET &FROM_DATE = EDIT(&ADATE1,'9999-99-99');
-SET &TO_DATE = EDIT(&ADATE2,'9999-99-99');
-*
SET SQLENGINE=SQLORA
SQL SET SERVER DWD_DLHCM
SQL
SELECT cf.card_type_code, sr.reason_code, oi.card_dcn, oi.oi_identifier, cs.sts, oi.oi_effective_dt, oi.oi_dl,
oi.item_count
FROM DWDH_OWNER.DWDHF_ORDER_ITEM oi
,DWDH_OWNER.DWDHD_STATUS_REASON sr
,DWDH_OWNER.DWDHD_CARDFILE_TYPE cf
,DWGL_OWNER.DWGLD_COMPANY c
,(select card_dcn, cssr.status_code sts
from dwdhf_card_stock, dwdhd_status_reason cssr
where dwdhf_card_stock.dhd_status_reason_id = cssr.id
and cssr.status_code = 'DEST') cs
WHERE oi.dhd_status_reason_id = sr.id and sr.cur_ind_flg = 'Y'
AND oi.dhd_cardfile_type_id = cf.id and cf.cur_ind_flg = 'Y'
AND oi.gld_company_id = c.id and c.cur_ind_flg = 'Y'
AND sr.STATUS_CODE = 'PROD_F'
AND sr.REASON_CODE IN ('CARD_DAMAGED', 'DATA_QUALITY', 'SIGNATURE_QUALITY', 'IMAGE_QUALITY', 'INC_DATA')
AND TO_CHAR( oi.oi_effective_dt, 'YYYY-MM-DD') BETWEEN '&FROM_DATE' AND '&TO_DATE'
and oi.card_dcn = cs.card_dcn (+)
ORDER BY 1,4,6
;
TABLE ON TABLE HOLD AS DR2V4
END
-RUN
-*? HOLD DR2V4
-*0DEFINITION OF HOLD FILE: DR2V4
-* 0FIELDNAME ALIAS FORMAT
-* CARD_TYPE_CODE E01 A30
-* REASON_CODE E02 A30
-* CARD_DCN E03 A100 MISSING = ON
-* OI_IDENTIFIER E04 A100
-* STS E05 A30 MISSING = ON
-* OI_EFFECTIVE_DT E06 HYYMDS
-* OI_DL E07 A17 MISSING = ON
-* ITEM_COUNT E08 P2
TABLE FILE DR2V4
SUM ITEM_COUNT/I7 NOPRINT
BY CARD_TYPE_CODE NOPRINT
PRINT
CARD_TYPE_CODE AS 'Card Type'
REASON_CODE AS 'Reason Code'
CARD_DCN AS 'DCN'
OI_IDENTIFIER AS 'Order ID'
STS AS 'Card Stock,Status'
OI_EFFECTIVE_DT AS 'Timestamp'
OI_DL AS 'DL'
BY
CARD_TYPE_CODE NOPRINT
BY
OI_IDENTIFIER NOPRINT
BY
OI_EFFECTIVE_DT NOPRINT
ON CARD_TYPE_CODE SUBFOOT
"Total HEADING
"DL Card and Health Card Contract Management"
"Detailed Card Production Failures Report"
"From: &ADATE1TEXT.EVAL To: &ADATE2TEXT.EVAL "
" "
-*FOOTING
ON TABLE SUBFOOT
"Total Card Production Failures : "Report ID: DR2V4 / Date: &RUN_DATE / Time: &RUN_TIME / <+34> Page ON TABLE SET PAGE-NUM OFF
ON TABLE PCHOLD FORMAT '&OUTPUT'
ON TABLE SET CSSURL '/approot/mtomis/report.css'
ON TABLE SET STYLE *
-*
-GOTO STY_&OUTPUT.EVAL
-*
-STY_HTML
-STY_EXL2K
-MRNOEDIT -INCLUDE STYLE011
-GOTO STY_END
-*
-STY_PDF
-MRNOEDIT -INCLUDE STYLE021
-*
-STY_EXCEL
-STY_END
ENDSTYLE
END
-RUN
-*
-IF &LINES GT 0 GOTO REPORT_END;
-*
-NO_DATA
-MRNOEDIT -INCLUDE MISI200
-*
-REPORT_END

Output:
DL Card and Health Card Contract Management
Detailed Card Production Failures Report
From: June 01 2007 To: June 30 2007



Card Type
Reason Code
DCN
Order ID Card Stock
Status
Timestamp
DL
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl1 2007/06/07 11:00:00 D1234-56789-00001
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl1 2007/06/08 11:00:00 D1234-56789-00001
DLCARD_V1 CARD_DAMAGED DL0000001 release4orderitemidentifierdl1 DEST 2007/06/10 11:00:00 D1234-56789-00001
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl10 2007/06/07 11:09:00 D1234-56789-00010
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl10 2007/06/08 11:09:00 D1234-56789-00010
DLCARD_V1 CARD_DAMAGED DL0000004 release4orderitemidentifierdl10 DEST 2007/06/10 11:09:00 D1234-56789-00010
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl11 2007/06/07 11:10:00 D1234-56789-00011
DLCARD_V1 IMAGE_QUALITY DL0001175 release4orderitemidentifierdl1180 2007/06/04 12:19:00 D1234-56789-01180
DLCARD_V1 SIGNATURE_QUALITY DL0001175 release4orderitemidentifierdl1180 2007/06/04 12:29:00 D1234-56789-01180
DLCARD_V1 IMAGE_QUALITY DL0001175 release4orderitemidentifierdl1180 2007/06/04 12:39:00 D1234-56789-01180
DLCARD_V1 IMAGE_QUALITY DL0001176 release4orderitemidentifierdl1181 2007/06/05 12:00:00 D1234-56789-01181
DLCARD_V1 SIGNATURE_QUALITY DL0001176 release4orderitemidentifierdl1181 2007/06/05 12:29:00 D1234-56789-01181
DLCARD_V1 IMAGE_QUALITY DL0001176 release4orderitemidentifierdl1181 2007/06/05 12:39:00 D1234-56789-01181
DLCARD_V1 IMAGE_QUALITY DL0001177 release4orderitemidentifierdl1182 2007/06/05 12:01:00 D1234-56789-01182
DLCARD_V1 IMAGE_QUALITY DL0001178 release4orderitemidentifierdl1183 2007/06/05 12:02:00 D1234-56789-01183
DLCARD_V1 CARD_DAMAGED DL0001179 release4orderitemidentifierdl1184 DEST 2007/06/05 13:13:00 D1234-56789-01184
DLCARD_V1 CARD_DAMAGED DL0001216 release4orderitemidentifierdl1184 DEST 2007/06/05 13:33:00 D1234-56789-01184
DLCARD_V1 CARD_DAMAGED DL0001217 release4orderitemidentifierdl1184 DEST 2007/06/05 13:53:00 D1234-56789-01184
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl12 2007/06/07 11:11:00 D1234-56789-00012
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl13 2007/06/07 11:12:00 D1234-56789-00013
DLCARD_V1 INC_DATA release4orderitemidentifierdl14 2007/06/07 11:13:00 D1234-56789-00014
DLCARD_V1 INC_DATA release4orderitemidentifierdl14 2007/06/08 11:13:00 D1234-56789-00014
DLCARD_V1 CARD_DAMAGED DL0000005 release4orderitemidentifierdl14 DEST 2007/06/10 11:13:00 D1234-56789-00014
DLCARD_V1 INC_DATA release4orderitemidentifierdl15 2007/06/07 11:14:00 D1234-56789-00015
DLCARD_V1 INC_DATA release4orderitemidentifierdl15 2007/06/08 11:14:00 D1234-56789-00015
DLCARD_V1 CARD_DAMAGED DL0000006 release4orderitemidentifierdl15 DEST 2007/06/10 11:14:00 D1234-56789-00015
DLCARD_V1 INC_DATA release4orderitemidentifierdl16 2007/06/07 11:15:00 D1234-56789-00016
DLCARD_V1 INC_DATA release4orderitemidentifierdl16 2007/06/08 11:15:00 D1234-56789-00016
DLCARD_V1 INC_DATA release4orderitemidentifierdl17 2007/06/07 11:16:00 D1234-56789-00017
DLCARD_V1 INC_DATA release4orderitemidentifierdl17 2007/06/08 11:16:00 D1234-56789-00017
DLCARD_V1 INC_DATA release4orderitemidentifierdl18 2007/06/07 11:17:00 D1234-56789-00018
DLCARD_V1 INC_DATA release4orderitemidentifierdl18 2007/06/08 11:17:00 D1234-56789-00018
DLCARD_V1 INC_DATA release4orderitemidentifierdl19 2007/06/07 11:18:00 D1234-56789-00019
DLCARD_V1 INC_DATA release4orderitemidentifierdl19 2007/06/08 11:18:00 D1234-56789-00019
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl2 2007/06/07 11:01:00 D1234-56789-00002
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl2 2007/06/08 11:01:00 D1234-56789-00002
DLCARD_V1 CARD_DAMAGED DL0000002 release4orderitemidentifierdl2 DEST 2007/06/10 11:01:00 D1234-56789-00002
DLCARD_V1 INC_DATA release4orderitemidentifierdl20 2007/06/07 11:19:00 D1234-56789-00020
DLCARD_V1 INC_DATA release4orderitemidentifierdl20 2007/06/08 11:19:00 D1234-56789-00020
DLCARD_V1 CARD_DAMAGED DL0000007 release4orderitemidentifierdl20 DEST 2007/06/10 11:19:00 D1234-56789-00020
DLCARD_V1 INC_DATA release4orderitemidentifierdl21 2007/06/07 11:20:00 D1234-56789-00021
DLCARD_V1 INC_DATA release4orderitemidentifierdl22 2007/06/07 11:21:00 D1234-56789-00022
DLCARD_V1 INC_DATA release4orderitemidentifierdl22 2007/06/08 11:21:00 D1234-56789-00022
DLCARD_V1 INC_DATA release4orderitemidentifierdl23 2007/06/07 11:22:00 D1234-56789-00023
DLCARD_V1 INC_DATA release4orderitemidentifierdl23 2007/06/08 11:22:00 D1234-56789-00023
DLCARD_V1 INC_DATA release4orderitemidentifierdl24 2007/06/07 11:23:00 D1234-56789-00024
DLCARD_V1 INC_DATA release4orderitemidentifierdl24 2007/06/08 11:23:00 D1234-56789-00024
DLCARD_V1 INC_DATA release4orderitemidentifierdl25 2007/06/07 11:24:00 D1234-56789-00025
DLCARD_V1 INC_DATA release4orderitemidentifierdl26 2007/06/07 11:25:00 D1234-56789-00026
DL Card and Health Card Contract Management
Detailed Card Production Failures Report
From: June 01 2007 To: June 30 2007



Card Type
Reason Code
DCN
Order ID Card Stock
Status
Timestamp
DL
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl27 2007/06/07 11:26:00 D1234-56789-00027
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl27 2007/06/08 11:26:00 D1234-56789-00027
DLCARD_V1 CARD_DAMAGED DL0000008 release4orderitemidentifierdl27 DEST 2007/06/10 11:26:00 D1234-56789-00027
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl28 2007/06/07 11:27:00 D1234-56789-00028
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl28 2007/06/08 11:27:00 D1234-56789-00028
DLCARD_V1 CARD_DAMAGED DL0000009 release4orderitemidentifierdl28 DEST 2007/06/10 11:27:00 D1234-56789-00028
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl29 2007/06/07 11:28:00 D1234-56789-00029
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl29 2007/06/08 11:28:00 D1234-56789-00029
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl3 2007/06/07 11:02:00 D1234-56789-00003
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl3 2007/06/08 11:02:00 D1234-56789-00003
DLCARD_V1 CARD_DAMAGED DL0000003 release4orderitemidentifierdl3 DEST 2007/06/10 11:02:00 D1234-56789-00003
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl30 2007/06/07 11:29:00 D1234-56789-00030
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl31 2007/06/07 11:30:00 D1234-56789-00031
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl31 2007/06/08 11:30:00 D1234-56789-00031
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl32 2007/06/07 11:31:00 D1234-56789-00032
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl32 2007/06/08 11:31:00 D1234-56789-00032
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl33 2007/06/07 11:32:00 D1234-56789-00033
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl33 2007/06/08 11:32:00 D1234-56789-00033
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl34 2007/06/07 11:33:00 D1234-56789-00034
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl35 2007/06/07 11:34:00 D1234-56789-00035
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl36 2007/06/07 11:35:00 D1234-56789-00036
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl37 2007/06/07 11:36:00 D1234-56789-00037
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl38 2007/06/07 11:37:00 D1234-56789-00038
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl39 2007/06/07 11:38:00 D1234-56789-00039
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl4 2007/06/07 11:03:00 D1234-56789-00004
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl4 2007/06/08 11:03:00 D1234-56789-00004
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl40 2007/06/07 11:39:00 D1234-56789-00040
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl41 2007/06/07 11:40:00 D1234-56789-00041
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl41 2007/06/08 11:40:00 D1234-56789-00041
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl42 2007/06/07 11:41:00 D1234-56789-00042
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl42 2007/06/08 11:41:00 D1234-56789-00042
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl43 2007/06/07 11:42:00 D1234-56789-00043
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl43 2007/06/08 11:42:00 D1234-56789-00043
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl44 2007/06/07 11:43:00 D1234-56789-00044
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl44 2007/06/08 11:43:00 D1234-56789-00044
DLCARD_V1 CARD_DAMAGED DL0000010 release4orderitemidentifierdl44 DEST 2007/06/10 11:43:00 D1234-56789-00044
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl45 2007/06/07 11:44:00 D1234-56789-00045
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl45 2007/06/08 11:44:00 D1234-56789-00045
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl46 2007/06/07 11:45:00 D1234-56789-00046
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl47 2007/06/07 11:46:00 D1234-56789-00047
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl48 2007/06/07 11:47:00 D1234-56789-00048
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl49 2007/06/07 11:48:00 D1234-56789-00049
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl5 2007/06/07 11:04:00 D1234-56789-00005
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl5 2007/06/08 11:04:00 D1234-56789-00005
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl50 2007/06/07 11:49:00 D1234-56789-00050
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl6 2007/06/07 11:05:00 D1234-56789-00006
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl6 2007/06/08 11:05:00 D1234-56789-00006
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl7 2007/06/07 11:06:00 D1234-56789-00007
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl7 2007/06/08 11:06:00 D1234-56789-00007
DL Card and Health Card Contract Management
Detailed Card Production Failures Report
From: June 01 2007 To: June 30 2007



Card Type
Reason Code
DCN
Order ID Card Stock
Status
Timestamp
DL
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl8 2007/06/07 11:07:00 D1234-56789-00008
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl8 2007/06/08 11:07:00 D1234-56789-00008
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl9 2007/06/07 11:08:00 D1234-56789-00009
Total DLCARD_V1 Production Failures : **

HCARD_V1 IMAGE_QUALITY release4orderitemidentifierhc1 2007/06/08 11:00:00
HCARD_V1 CARD_DAMAGED HC0000001 release4orderitemidentifierhc10 DEST 2007/06/08 11:09:00
HCARD_V1 IMAGE_QUALITY release4orderitemidentifierhc11 2007/06/08 11:10:00
HCARD_V1 IMAGE_QUALITY release4orderitemidentifierhc12 2007/06/08 11:11:00
HCARD_V1 IMAGE_QUALITY release4orderitemidentifierhc13 2007/06/08 11:12:00
HCARD_V1 INC_DATA release4orderitemidentifierhc14 2007/06/08 11:13:00
HCARD_V1 INC_DATA release4orderitemidentifierhc15 2007/06/08 11:14:00
HCARD_V1 INC_DATA release4orderitemidentifierhc16 2007/06/08 11:15:00
HCARD_V1 INC_DATA release4orderitemidentifierhc17 2007/06/08 11:16:00
HCARD_V1 INC_DATA release4orderitemidentifierhc18 2007/06/08 11:17:00
HCARD_V1 INC_DATA release4orderitemidentifierhc19 2007/06/08 11:18:00
HCARD_V1 IMAGE_QUALITY release4orderitemidentifierhc2 2007/06/08 11:01:00
HCARD_V1 CARD_DAMAGED HC0000002 release4orderitemidentifierhc20 DEST 2007/06/08 11:19:00
HCARD_V1 INC_DATA release4orderitemidentifierhc21 2007/06/08 11:20:00
HCARD_V1 INC_DATA release4orderitemidentifierhc22 2007/06/08 11:21:00
HCARD_V1 INC_DATA release4orderitemidentifierhc23 2007/06/08 11:22:00
HCARD_V1 INC_DATA release4orderitemidentifierhc24 2007/06/08 11:23:00
HCARD_V1 INC_DATA release4orderitemidentifierhc25 2007/06/08 11:24:00
HCARD_V1 INC_DATA release4orderitemidentifierhc26 2007/06/08 11:25:00
HCARD_V1 SIGNATURE_QUALITY release4orderitemidentifierhc27 2007/06/08 11:26:00
HCARD_V1 SIGNATURE_QUALITY release4orderitemidentifierhc28 2007/06/08 11:27:00
HCARD_V1 SIGNATURE_QUALITY release4orderitemidentifierhc29 2007/06/08 11:28:00
HCARD_V1 IMAGE_QUALITY release4orderitemidentifierhc3 2007/06/08 11:02:00
HCARD_V1 CARD_DAMAGED HC0000003 release4orderitemidentifierhc30 DEST 2007/06/08 11:29:00
HCARD_V1 SIGNATURE_QUALITY release4orderitemidentifierhc31 2007/06/08 11:30:00
HCARD_V1 SIGNATURE_QUALITY release4orderitemidentifierhc32 2007/06/08 11:31:00
HCARD_V1 SIGNATURE_QUALITY release4orderitemidentifierhc33 2007/06/08 11:32:00
HCARD_V1 SIGNATURE_QUALITY release4orderitemidentifierhc34 2007/06/08 11:33:00
HCARD_V1 SIGNATURE_QUALITY release4orderitemidentifierhc35 2007/06/08 11:34:00
HCARD_V1 SIGNATURE_QUALITY release4orderitemidentifierhc36 2007/06/08 11:35:00
HCARD_V1 SIGNATURE_QUALITY release4orderitemidentifierhc37 2007/06/08 11:36:00
HCARD_V1 SIGNATURE_QUALITY release4orderitemidentifierhc38 2007/06/08 11:37:00
HCARD_V1 SIGNATURE_QUALITY release4orderitemidentifierhc39 2007/06/08 11:38:00
HCARD_V1 IMAGE_QUALITY release4orderitemidentifierhc4 2007/06/08 11:03:00
HCARD_V1 CARD_DAMAGED HC0000004 release4orderitemidentifierhc40 DEST 2007/06/08 11:39:00
HCARD_V1 DATA_QUALITY release4orderitemidentifierhc41 2007/06/08 11:40:00
HCARD_V1 DATA_QUALITY release4orderitemidentifierhc42 2007/06/08 11:41:00
HCARD_V1 DATA_QUALITY release4orderitemidentifierhc43 2007/06/08 11:42:00
HCARD_V1 DATA_QUALITY release4orderitemidentifierhc44 2007/06/08 11:43:00
HCARD_V1 DATA_QUALITY release4orderitemidentifierhc45 2007/06/08 11:44:00
HCARD_V1 DATA_QUALITY release4orderitemidentifierhc46 2007/06/08 11:45:00
HCARD_V1 DATA_QUALITY release4orderitemidentifierhc47 2007/06/08 11:46:00
HCARD_V1 DATA_QUALITY release4orderitemidentifierhc48 2007/06/08 11:47:00
HCARD_V1 DATA_QUALITY release4orderitemidentifierhc49 2007/06/08 11:48:00
HCARD_V1 IMAGE_QUALITY release4orderitemidentifierhc5 2007/06/08 11:04:00
DL Card and Health Card Contract Management
Detailed Card Production Failures Report
From: June 01 2007 To: June 30 2007



Card Type
Reason Code
DCN
Order ID Card Stock
Status
Timestamp
DL
HCARD_V1 CARD_DAMAGED HC0000005 release4orderitemidentifierhc50 DEST 2007/06/08 11:49:00
HCARD_V1 IMAGE_QUALITY release4orderitemidentifierhc6 2007/06/08 11:05:00
HCARD_V1 IMAGE_QUALITY release4orderitemidentifierhc7 2007/06/08 11:06:00
HCARD_V1 IMAGE_QUALITY release4orderitemidentifierhc8 2007/06/08 11:07:00
HCARD_V1 IMAGE_QUALITY release4orderitemidentifierhc9 2007/06/08 11:08:00
Total HCARD_V1 Production Failures : 50

Total Card Production Failures : **
Report ID: DR2V4 / Date: October 23, 2007 / Time: 11:44:40 / Page 4 of 4

WF V7.7.03
Platform: AIX 6.1 64-bit, WinXP, IE 8.0
Output Formats: Html, Pdf, Excel

In case your count is just too wide for the default count width (5 character), have you tried

 
SET COUNTWIDTH=ON

which expands it to 9 characters?

Thanks, I tried what PBrightwell said yesterday and it worked so my problem is fixed. I will keep your suggestion in mind next time. The field I had to display was a P2 format. Rgds.