Does anyone know how I can move column to farther the right in a FML report?

I like what this produces:

TABLE FILE ACCOUNTHIER
SUM
     'DV' AS ''
FOR
     ACCOUNTHIER.ACCOUNT.ASSET_LINE
'A' AS CAPTION LABEL R1 OVER
'A' GET CHILDREN ALL AS CAPTION LABEL R2 OVER
'BAR' AS '-' OVER
'D' AS CAPTION LABEL R4 OVER
BAR AS '='
...

Result:

Opening         $123,456
Net Transfers       $123
Income              $456
                -------- 
Closing         $234,567
                ========

However, I need the column containg the numbers printing farther right

If I add spacer columns like below:

[CODE]
TABLE FILE ACCOUNTHIER
SUM
COMPUTE SP1/A1 = ' '; AS ''
COMPUTE SP2/A1 = ' '; AS ''
COMPUTE SP3/A1 = ' '; AS ''
COMPUTE SP4/A1 = ' '; AS ''
COMPUTE SP5/A1 = ' '; AS ''
COMPUTE SP6/A1 = ' '; AS ''
COMPUTE SP7/A1 = ' '; AS ''
COMPUTE SP8/A1 = ' '; AS ''
COMPUTE SP9/A1 = ' '; AS ''
'DV' AS ''
FOR
ACCOUNTHIER.ACCOUNT.ASSET_LINE
'A' AS CAPTION LABEL R1 OVER
'A' GET CHILDREN ALL AS CAPTION LABEL R2 OVER
'BAR' AS '-' OVER
'D' AS CAPTION LABEL R4 OVER
BAR AS '='

Result:
Opening $123,456
Net Transfers $123
Income $456
- - - - - - - - - --------
Closing $234,567
= = = = = = = = = ========
[CODE]

In other words the spacing get underlines.

I have tried to format the BAR to be white with no luck either.

Output is HTML only

Thanks,

Fernando

Have you tried a text line of blanks? e.g.
OVER
" " OVER
..
If this doesn't work you might try
ON TABLE PCHOLD FORMAT DHTML

Second result should have read:

  
Result:
Opening                           $123,456
Net Transfers                         $123
Income                                $456
                - - - - - - - - - -------- 
Closing                           $234,567
                = = = = = = = = = ========

Gerald,

I am using 7.13 so no FORMAT DHTML. As well, the OVER adds a row. I need to have column physically printed farther right.

I was able to use:

TYPE=REPORT,
COLUMN=DVA,
SQUEEZE=2.53,
$

This makes it goes farther right but then the --- becomes very long

  
Result:
Opening                           $123,456
Net Transfers                         $123
Income                                $456
                -------------------------- 
Closing                           $234,567
                ==========================

Fernando

How about using CSS:

TABLE FILE CAR
SUM
SALES/D6 AS ''
FOR COUNTRY
'ENGLAND' OVER
'FRANCE' OVER
'ITALY' OVER
BAR AS '='

ON TABLE HOLD AS H001 FORMAT HTMTABLE
ON TABLE SET PAGE NOLEAD
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLESHEET *
GRID=OFF, $
TYPE=REPORT, COLUMN=N1, CLASS=DATA_N1, $
END
-RUN

-HTMLFORM BEGIN
<STYLE>
BODY { font-family: "Courier New", Courier, mono; font-size: 11px; }
.DATA_N1 { padding-right: 100px; }
</STYLE>
!IBI.FIL.H001;
-HTMLFORM END