May 03, 2005, 05:36 PM
Kameshalign padded fields
Trying to align the padded field but not working properly in PDF.
ex: Run the following code and see the output and it looks correct(Properly aligned).
ie., Units $111111
Product Cappucino
If you uncomment the first line in Define, that is make UNITS to 0 then run the report.
output will look like,
Units $.00
Product Cappucino
I want everything to be aligned left..
DEFINE FILE GGSALES
-*UNITS/I8=0;
UNIT/P17.2CM=UNITS;
END
TABLE FILE GGSALES
SUM UNITS DOLLARS
BY CATEGORY NOPRINT
BY PRODUCT NOPRINT
ON CATEGORY SUBHEAD
"UNITS <+0> <ST.UNIT "
"PRODUCT <+0> <PRODUCT"
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=SUBHEAD,LINE=1,OBJECT=FIELD,ITEM=1,WIDTH=1.6,JUSTIFY=DECIMAL(.6),$
TYPE=SUBHEAD,LINE=2,OBJECT=FIELD,ITEM=1,JUSTIFY=DECIMAL(.6),$
ENDSTYLE
END
-EXIT
May 03, 2005, 05:49 PM
Francis MarianiThis seems to do what you require:
DEFINE FILE GGSALES
-*UNITS/I8=0;
UNIT/P17.2CM=UNITS;
END
TABLE FILE GGSALES
SUM UNITS DOLLARS
BY CATEGORY NOPRINT
BY PRODUCT NOPRINT
ON CATEGORY SUBHEAD
"UNITS <ST.UNIT"
"PRODUCT <PRODUCT"
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=SUBHEAD,ITEM=1,WIDTH=1,COLOR=BLUE,$
TYPE=SUBHEAD,ITEM=2,WIDTH=2,JUSTIFY=LEFT, COLOR=GREEN, $
ENDSTYLE
END
May 03, 2005, 07:58 PM
reFOCUSingAre you trying to keep the decimal aligned and left justify the numbers?