Daily Archives: January 3, 2014

WebFOCUS – Showing / Suppressing leading zeroes

WebFOCUS is a rich language that you can do almost anything with. Unfortunately, the depth of the language makes it hard to find how to do certain tasks; I’ve had to search very hard in our documentation, Focal Point, and Google to accomplish what I would consider common tasks.

Here’s an example. When I first started to learn WebFOCUS, I was trying to show the leading zero of a fractional 0 value in a report.

I.e. a zero real value shows up like .00 instead of 0.00.

In most cases that’s fine to save real estate. However, I like it with the leading zero to help with visually aligning decimal places. Simple enough task right? It is, but you have to know the right command and what to search for.

I searched for (always preceding with WebFOCUS):

• Add a zero to a real number in a report

• Suppressing zero values in report (the opposite)

• Formatting numeric values

It took a while (20 minutes), to find what I was looking for. It was:

SET CENT-ZERO = ON

It’s easy to do, just hard to find how to do it.

This got me thinking; I thought it would be useful to start blogging about various features I’ve found and sharing them with Google. The trick is adding the right keywords to make it easier to find things.

Hopefully, everyone can benefit from this activity. I know I will when a have a mental lapse. 😀