September 09, 2015, 10:49 AM
Ramkumar - Webfous [CLOSED] Positioning Caption/Title of Grandtotal
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>, September 17, 2015 01:14 PM September 10, 2015, 11:10 AM
Shahram 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>, September 11, 2015 07:17 PM September 10, 2015, 11:13 AM
Shahram 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 ENDSeptember 10, 2015, 11:14 AM
Shahram 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 September 10, 2015, 11:17 AM
Shahram 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.
September 10, 2015, 11:39 AM
MartinY Put your code between code tag.
September 11, 2015, 09:45 AM
Ramkumar - Webfous Thank you Shahram. You can mail me the code at ram.jesura@gmail.com.
I will check.
September 25, 2015, 05:40 AM
Dev BELOW WILL HELP TO MAKE THE HELLO TOTAL IN THE 4TH COLUMN
TYPE=GRANDTOTAL,OBJECT=TAG,JUSTIFY=RIGHT,$