IBI WebFOCUS – Leading zeroes Display/ Suppress
WebFOCUS has lots of flexibility because it has option to write code in text editor. That is very unique feature in WebFOCUS which separates it from other reporting tools. There are certain occasions where we put lots of effort to achieve certain requirement in our report. But if you know the keywords, it can be done in minutes. Recently one of my colleague came to me asking for the solution to display leading zeroes in the report. He spent almost 3-4 hours and still continued. The requirement was to display 0.00 instead of .00. The solution was pretty simple. You need to write below code at start of your fex file: SET CENT-ZERO = ON It was very easy to do it but very difficult to find out the keyword. If you have to suppress leading zeroes it should be turned off. SET CENT-ZERO = OFF I thought it is worth sharing as it can save some time for your during coding. Please share your thoughts/ feedback's. Happy coding in WebFOCUS!!!!