Focal Point
align padded fields

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9461058331

May 03, 2005, 05:36 PM
Kamesh
align 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 Mariani
This 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
reFOCUSing
Are you trying to keep the decimal aligned and left justify the numbers?