[SOLVED] issue with display of number field in APDF
I've got a batch number that I want to display. In the oracle database it is a number (8), for example in PDF it displays as 223344 while in APDF it displays as 223,344. How do I get rid of the comma?This message has been edited. Last edited by: Kerry,
WebFOCUS 8105m as well as 7.6.11 Windows 10
July 14, 2010, 07:33 AM
David Glick
APDF is Flex embedded in PDF so it is subject to how Flex works. Flex uses the locale or Regional Settings for the machine which is to have a comma for every 3 digits. If you modify the Regional Settings, you should be able to get what you want, however, Regional Settings affects more than Flex of course.
David Glick Director WebFOCUS App Studio and WebFOCUS Developer Studio WebFOCUS Division Information Builders, Inc. Direct (917) 339-5560 Voice Mail (212) 736-6250 x3560 Fax (212) 947-5168 Email david_glick@ibi.com
July 14, 2010, 10:24 AM
Francis Mariani
Could you use the numeric conversion functions FTOA or PTOA to convert the number to alpha? This avoids fooling around with regional settings.
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 14, 2010, 01:16 PM
Laura1
Converting it to a character field is not an option as it is used as a drilldown parameter.
I tried changing my regional setting, but it didn't seem to make a difference.
WebFOCUS 8105m as well as 7.6.11 Windows 10
July 14, 2010, 03:18 PM
FrankDutch
Well Lauri, that is not a real good reason you can both use the original field and the converted format field in the same report. Make the original invisible but use it to drill down.
Frank
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7
July 19, 2010, 10:51 AM
Laura1
I know that can work Frank, but I guess I was hoping for a patch or something along those lines so I don't have to mess with code on 50+ reports.
