I need help in doing the following:

TABLE FILE PD_INFO
PRINT CNT NOPRINT
AMOUNT/P17.2CM AS ''
TRIMMEMO AS ''
WHERE DEBITCREDIT EQ 'C'
BY TRNCODE NOPRINT SKIP-LINE
BY DESCRIPTION NOPRINT
BY HIGHEST AMOUNT NOPRINT
ON TRNCODE NOPRINT SUBHEAD
""ON TRNCODE SUB-TOTAL AMOUNT AS 'Subtotal:

Basically I want the output of Subtotal to print as:
Subtotal: 6 ACH Credit(s)
$4,552.00

If you notice I want the subcount of cnt(which has the value of 1) and description to print in subtotal command.

Any help will be appreciated.

Vipul

My earlier postiing got truncated: it is

TABLE FILE PD_INFO
PRINT CNT NOPRINT
AMOUNT/P17.2CM AS ''
TRIMMEMO AS ''
WHERE DEBITCREDIT EQ 'C'
BY TRNCODE NOPRINT SKIP-LINE
BY DESCRIPTION NOPRINT
BY HIGHEST AMOUNT NOPRINT
ON TRNCODE NOPRINT SUBHEAD
""ON TRNCODE SUB-TOTAL CNT AMOUNT AS 'Subtotal:
Basically I want the field description and count of cnt to print on Subtotal before the subtotal is printed.

I want my output to be as:
Subtotal: 6 ACH Credit(s)
$1000.00

Any help will be appreciated.

Vipul

My earlier postiing got truncated: it is

TABLE FILE PD_INFO
PRINT CNT NOPRINT
AMOUNT/P17.2CM AS ''
TRIMMEMO AS ''
WHERE DEBITCREDIT EQ 'C'
BY TRNCODE NOPRINT SKIP-LINE
BY DESCRIPTION NOPRINT
BY HIGHEST AMOUNT NOPRINT
ON TRNCODE SUB-TOTAL CNT AMOUNT AS 'Subtotal:
Basically I want the field description and count of cnt to print on Subtotal before the subtotal is printed.

I want my output to be as:
Subtotal: 6 ACH Credits
$1000.00

Any help will be appreciated.

Vipul

You will need to remove the SUBTOTAL and then add

ON TRNCODE SUBFOOT
"Subtotal: "
SUBTOTAL lines will always appear before SUBFOOTs so you will need to manually code both of them in a SUBFOOT.

Let's try that again:


You will need to remove the SUBTOTAL and then add

ON TRNCODE SUBFOOT
"Subtotal: <CNT.CNT <DESCRIPTION </1"
"<ST.AMOUNT"

SUBTOTAL lines will always appear before SUBFOOTs so you will need to manually code both of them in a SUBFOOT.

Thanks Mickey,

It worked....

Mickey,

How will I get the formatting in
Thanks

Did not previewed. Somehow it does not like gt , lt symbols.

Ok How will I get the formatting in st.amount field it is a dollar field.

Thanks in advence

Vipul

Create a COMPUTE field (with the new format) equal to the AMOUNT field. Then change the SUBFOOT to do an ST. on the COMPUTE field. I do not know if there is a more elegant way to do this but it works. The following is an example using the CAR file.

TABLE FILE CAR
PRINT RCOST/D12M DCOST
COMPUTE NEWRCOST/D12M=RCOST; NOPRINT
BY COUNTRY
BY CAR
ON COUNTRY SUBFOOT
"<ST.NEWRCOST"
END