Focal Point
(Solved) HTML output, D12.2CBN format, inline message, Dollar Sign only on first row

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

August 19, 2015, 03:06 PM
Joni Campbell - Europa Sports
(Solved) HTML output, D12.2CBN format, inline message, Dollar Sign only on first row
I'm new to HTML output format. The output of fields that contain dollar amounts (format D12.2CBN,) are only displaying the dollar sign on the 1st row. Is this as expected? Do I need to use FPRINT to create a different field that will contain the $ for every row?

This message has been edited. Last edited by: Joni Campbell - Europa Sports,


8009
Windows, HTML, AHTML, Excel
In FOCUS since 1983
August 19, 2015, 04:04 PM
prodrigu
Joni,

Try using format D12MC or D12M.

  
TABLE FILE CAR
SUM
SALES/D12MC
RETAIL_COST/D10M
BY COUNTRY SUBTOTAL
BY CAR
BY MODEL
END
-EXIT


Thanks,
prodrigu


Prod: WebFOCUS 7.7.03: Win 2008 & AIX hub/Servlet Mode; sub: AS/400 JDE; mostly Self Serve; DBs: Oracle, JDE, SQLServer; various output formats
August 19, 2015, 04:17 PM
Joni Campbell - Europa Sports
prodrigu - That did the trick. We prefer to have the non-moving dollar sign, but I guess that it'll have to be a moving dollar sign for this report.

Do you have any idea why this is the case?

Thank you for the answer, I'll mark this as closed.


8009
Windows, HTML, AHTML, Excel
In FOCUS since 1983