I have a report that has 3 rows of 2 decimal place dollar amounts and 1 row with a 1 decimal number. I need to have all 4 rows right justified regardless of the varying length of the number in each row. When I right justify each row in the stylesheet, the numbers still shift whenever the length of the numbers change on an individual row. The report is a PDF report. See example below. Thank you.

Total Dollars1: $159,616.13
Tot Dollars2:    $19,528.00
Dollar3:          $4,088.13
Num4:                   1.1
            OR
Total Dollars1:  $59,616.13
Tot Dollars2:    $19,528.00
Dollar3:            $488.13
Num4:                    .0

  

Dev Studio 8009

This message has been edited. Last edited by: Michele Brooks,

Can you create a CAR file demo, because Total columns are usually automatically right justified. So not sure what your asking for exactly.

Michele, I think for PDF reports, you can solve this by specifying a width for each of the two simulated columns of the subfoot:

TABLE FILE CAR
SUM
SALES
COMPUTE TOT1/D10.2M = WEIGHT; NOPRINT
COMPUTE TOT2/D10.2M = HEIGHT; NOPRINT
COMPUTE TOT3/D10.2M = LENGTH; NOPRINT
COMPUTE NUM4/D10.1 = WIDTH; NOPRINT
BY COUNTRY
ON COUNTRY SUBFOOT
"Total Dollars1: <ST.TOT1"
"Total Dollars2: <ST.TOT2"
"Dollars3: <ST.TOT3"
"Num4: <ST.NUM4"

ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *
TYPE=REPORT, SQUEEZE=ON, UNITS=INCHES, FONT='ARIAL',
SIZE=9, BORDER=1, BORDER-COLOR=SILVER,
$
TYPE=SUBFOOT, ITEM=1, WIDTH=1.0, COLOR=GREEN, $
TYPE=SUBFOOT, ITEM=2, JUSTIFY=RIGHT, WIDTH=1.0, COLOR=BLUE, $
ENDSTYLE

ON TABLE PCHOLD FORMAT PDF
END

Make sure that the width is wide enough for the text and the maximum numeric values...

[OFFTOPIC]BTW Gavin, nice hair - a Viking in a suit![/OFFTOPIC]

quote:

[OFFTOPIC]BTW Gavin, nice hair - a Viking in a suit![/OFFTOPIC]

Haha.. Yea, I was inspired by your lack of..

I thank everyone for the feedback. It turns out that I had the wrong line number for the line that was not right justified. I am closing this post. Thanks again everyone.