September 21, 2007, 09:40 AM
FernandoPlacing a FML column in output
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
September 21, 2007, 11:13 AM
GCohenHave you tried a text line of blanks? e.g.
OVER
" " OVER
..
If this doesn't work you might try
ON TABLE PCHOLD FORMAT DHTML
September 21, 2007, 01:34 PM
FernandoSecond 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
September 24, 2007, 10:13 AM
Francis MarianiHow 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
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server