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     on subtotal: subtotal of noprint field and embed of another field in literal
Go
New
Search
Notify
Tools
Reply
  
on subtotal: subtotal of noprint field and embed of another field in literal
 Login/Join
 
<Vipul>
posted
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
 
Reply With QuoteReport This Post
<Vipul>
posted
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
 
Reply With QuoteReport This Post
<Vipul>
posted
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
 
Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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.
 
Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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.
 
Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003Reply With QuoteReport This Post
<Vipul>
posted
Thanks Mickey,

It worked....
 
Reply With QuoteReport This Post
<Vipul>
posted
Mickey,

How will I get the formatting in
Thanks
 
Reply With QuoteReport This Post
<Vipul>
posted
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
 
Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     on subtotal: subtotal of noprint field and embed of another field in literal

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