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     [CLOSED] Positioning Caption/Title of Grandtotal
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Positioning Caption/Title of Grandtotal
 Login/Join
 
Guru
posted
I am trying to find options to position the Title of a Grandtotal.. In the below code I want the tile 'Hello Total' to be displayed either in the 4th column or one column with colspan 4 and Right aligned.. Is there a direct way doing this?

TABLE FILE CAR
PRINT 
     CAR.BODY.SEATS
     CAR.BODY.DEALER_COST
     CAR.BODY.RETAIL_COST
     CAR.BODY.SALES
     CAR.SPECS.LENGTH
     CAR.SPECS.WIDTH
     CAR.SPECS.HEIGHT
     CAR.SPECS.WEIGHT
     CAR.SPECS.WHEELBASE
BY  CAR.ORIGIN.COUNTRY
BY  CAR.COMP.CAR
BY  CAR.CARREC.MODEL
BY  CAR.BODY.BODYTYPE
ON TABLE SUBTOTAL AS 'Hello Total'
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
$
TYPE=GRANDTOTAL,
     JUSTIFY=RIGHT,
$
ENDSTYLE
END
 


I can go for one more HOLD file and then do a More or append. But I am checking for options to do this in a single Table file request.

Thanks.

This message has been edited. Last edited by: <Kathryn Henning>,


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Reply With QuoteReport This Post
Member
posted Hide Post
I would suggest to put your total on the page footing with alignment grid on. All in GUI.

TABLE FILE CAR
PRINT 
     CAR.BODY.SEATS
     CAR.BODY.DEALER_COST
     CAR.BODY.RETAIL_COST
     CAR.BODY.SALES
     CAR.SPECS.LENGTH
     CAR.SPECS.WIDTH
     CAR.SPECS.HEIGHT
     CAR.SPECS.WEIGHT
     CAR.SPECS.WHEELBASE
BY  CAR.ORIGIN.COUNTRY
BY  CAR.COMP.CAR
BY  CAR.CARREC.MODEL
BY  CAR.BODY.BODYTYPE
ON TABLE SUBFOOT
" <+0> <+0> <+0>Hello Total<TOT.SEATS<TOT.DEALER_COST<TOT.RETAIL_COST<TOT.SALES<TOT.LENGTH<TOT.WIDTH<TOT.HEIGHT<TOT.WEIGHT<TOT.WHEELBASE"
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
$
TYPE=TABFOOTING,
     HEADALIGN=BODY,
$
TYPE=TABFOOTING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     COLSPAN=1,
     JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=2,
     COLSPAN=1,
     JUSTIFY=LEFT,
$
TYPE=TABFOOTING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=3,
     COLSPAN=1,
     JUSTIFY=LEFT,
$
TYPE=TABFOOTING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=4,
     COLSPAN=1,
     JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
     LINE=1,
     OBJECT=FIELD,
     ITEM=1,
     COLSPAN=1,
     JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
     LINE=1,
     OBJECT=FIELD,
     ITEM=2,
     COLSPAN=1,
     JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
     LINE=1,
     OBJECT=FIELD,
     ITEM=3,
     COLSPAN=1,
     JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
     LINE=1,
     OBJECT=FIELD,
     ITEM=4,
     COLSPAN=1,
     JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
     LINE=1,
     OBJECT=FIELD,
     ITEM=5,
     COLSPAN=1,
     JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
     LINE=1,
     OBJECT=FIELD,
     ITEM=6,
     COLSPAN=1,
     JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
     LINE=1,
     OBJECT=FIELD,
     ITEM=7,
     COLSPAN=1,
     JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
     LINE=1,
     OBJECT=FIELD,
     ITEM=8,
     COLSPAN=1,
     JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
     LINE=1,
     OBJECT=FIELD,
     ITEM=9,
     COLSPAN=1,
     JUSTIFY=RIGHT,
$
TYPE=GRANDTOTAL,
     JUSTIFY=RIGHT,
$
ENDSTYLE
END

This message has been edited. Last edited by: <Kathryn Henning>,


All Releases
All OS, All Outputs
 
Posts: 15 | Registered: October 24, 2014Reply With QuoteReport This Post
Member
posted Hide Post
Sorry. after my last post, I have noticed that it is chopping my code. I am trying it again.
TABLE FILE CAR
PRINT
CAR.BODY.SEATS
CAR.BODY.DEALER_COST
CAR.BODY.RETAIL_COST
CAR.BODY.SALES
CAR.SPECS.LENGTH
CAR.SPECS.WIDTH
CAR.SPECS.HEIGHT
CAR.SPECS.WEIGHT
CAR.SPECS.WHEELBASE
BY CAR.ORIGIN.COUNTRY
BY CAR.COMP.CAR
BY CAR.CARREC.MODEL
BY CAR.BODY.BODYTYPE
ON TABLE SUBFOOT
" <+0> <+0> <+0>Hello Total
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
$
TYPE=TABFOOTING,
HEADALIGN=BODY,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=2,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=3,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=4,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=FIELD,
ITEM=1,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=FIELD,
ITEM=2,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=FIELD,
ITEM=3,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=FIELD,
ITEM=4,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=FIELD,
ITEM=5,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=FIELD,
ITEM=6,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=FIELD,
ITEM=7,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=FIELD,
ITEM=8,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=FIELD,
ITEM=9,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=GRANDTOTAL,
JUSTIFY=RIGHT,
$
ENDSTYLE
END


All Releases
All OS, All Outputs
 
Posts: 15 | Registered: October 24, 2014Reply With QuoteReport This Post
Member
posted Hide Post
It did it again I am wrapping the SUBFOOT line. you need to fix it in your code.
TABLE FILE CAR
PRINT
CAR.BODY.SEATS
CAR.BODY.DEALER_COST
CAR.BODY.RETAIL_COST
CAR.BODY.SALES
CAR.SPECS.LENGTH
CAR.SPECS.WIDTH
CAR.SPECS.HEIGHT
CAR.SPECS.WEIGHT
CAR.SPECS.WHEELBASE
BY CAR.ORIGIN.COUNTRY
BY CAR.COMP.CAR
BY CAR.CARREC.MODEL
BY CAR.BODY.BODYTYPE
ON TABLE SUBFOOT
" <+0> <+0> <+0>Hello Total

ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
$
TYPE=TABFOOTING,
HEADALIGN=BODY,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=2,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=3,
COLSPAN=1,
JUSTIFY=LEFT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=4,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=FIELD,
ITEM=1,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=FIELD,
ITEM=2,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=FIELD,
ITEM=3,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=FIELD,
ITEM=4,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=FIELD,
ITEM=5,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=FIELD,
ITEM=6,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=FIELD,
ITEM=7,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=FIELD,
ITEM=8,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=FIELD,
ITEM=9,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=GRANDTOTAL,
JUSTIFY=RIGHT,
$
ENDSTYLE
END


All Releases
All OS, All Outputs
 
Posts: 15 | Registered: October 24, 2014Reply With QuoteReport This Post
Member
posted Hide Post
After three tries, it still chopping my code.
Please send me an email to shahram_sazedj@ibi.com and I will send you the complete code.


All Releases
All OS, All Outputs
 
Posts: 15 | Registered: October 24, 2014Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Put your code between code tag.


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2341 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Guru
posted Hide Post
Thank you Shahram. You can mail me the code at ram.jesura@gmail.com.

I will check.


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Reply With QuoteReport This Post
Gold member
posted Hide Post
BELOW WILL HELP TO MAKE THE HELLO TOTAL IN THE 4TH COLUMN
TYPE=GRANDTOTAL,OBJECT=TAG,JUSTIFY=RIGHT,$


8202, 8105M, 7.7.03
 
Posts: 79 | Registered: June 12, 2012Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Positioning Caption/Title of Grandtotal

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