Hi All, i am running a simple report which contains all the numeric data,my question is i want to include '$' symbol in front of all the numerical data values.need to know How can i achieve it.This message has been edited. Last edited by: Kerry,
WebFOCUS Version 7.6.7 windows PDF
July 15, 2009, 03:46 PM
GinnyJakes
Kiran,
Please look up field format options in the documentation. The formats you are looking for are
Floating dollar
D7M 6148 $6,148
Non-floating dollar
D7N 5432 $ 5,432
GINNY, your solution is correct,but i want to know if i have ten columns of numerical data,then inorder to use D7M or D10M from the D12.2 for these columns where exactly i have to modify it.
WebFOCUS Version 7.6.7 windows PDF
July 15, 2009, 04:05 PM
Francis Mariani
TABLE FILE CAR
SUM SALES/D10M
BY COUNTRY
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
July 15, 2009, 04:12 PM
kiran
got it,thanks Francis.
WebFOCUS Version 7.6.7 windows PDF
July 15, 2009, 05:29 PM
Doug
As Ginny suggested, "Please look up field format options in the documentation.". That way you'll have a better understanding of what you need, now and in the future, instead of just this answer to this issue now.
In FOCUS Since 1983 ~ from FOCUS to WebFOCUS. Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
July 16, 2009, 09:54 AM
kiran
doug,i will refer to the documentation which Ginny suggeste.
WebFOCUS Version 7.6.7 windows PDF
July 16, 2009, 01:42 PM
Doug
Kiran, Did you find what you needed?
July 17, 2009, 10:55 AM
ira
To be a better developer, follow Ginny's suggestion it will help you be better prepared in the long run. I am throwing in an example just in case you're in an immediate pinch.
Good luck, Ira
quote:
TABLE FILE CAR PRINT DCOST/D12.2M BY COUNTRY BY CAR END -RUN