Report Builder Supressing Zeros

Juliet -

Double click on the band line in report builder. Add conditional printing
if the variable has a non-zero value.

HTH,
Calvin

----- Original Message -----
From: Juliet Martin <jmartin@...>
To: <vantage@egroups.com>
Sent: Wednesday, November 29, 2000 2:58 PM
Subject: [Vantage] Report Builder Supressing Zeros


> Is there any easy way to suppress zeros in a Report Builder Report on a
> number that you have formatted with 2 decimals. I am writing an Aged
> Receivables Report and there are not always dollars in the 60 or 90 day
> columns. So my report has a lot of .00 on it. I know that there is
> probably something really simple here that I am missing but I am willing
> to bruise my ego a bit to get this done. If I don't show decimals then
> I wouldn't be having this problem but unfortunately I need the 2 decimal
> places.
>
> Juliet Martin
>
>
> We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go
to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)
Is there any easy way to suppress zeros in a Report Builder Report on a
number that you have formatted with 2 decimals. I am writing an Aged
Receivables Report and there are not always dollars in the 60 or 90 day
columns. So my report has a lot of .00 on it. I know that there is
probably something really simple here that I am missing but I am willing
to bruise my ego a bit to get this done. If I don't show decimals then
I wouldn't be having this problem but unfortunately I need the 2 decimal
places.

Juliet Martin
Juliet,

Double click on field in report writer

Click on FORMAT button

Click OFF - "Show at least 1 digit"

Todd Anderson

-----Original Message-----
From: Juliet Martin [mailto:jmartin@...]
Sent: Wednesday, November 29, 2000 2:58 PM
To: vantage@egroups.com
Subject: [Vantage] Report Builder Supressing Zeros


Is there any easy way to suppress zeros in a Report Builder Report on a
number that you have formatted with 2 decimals. I am writing an Aged
Receivables Report and there are not always dollars in the 60 or 90 day
columns. So my report has a lot of .00 on it. I know that there is
probably something really simple here that I am missing but I am willing
to bruise my ego a bit to get this done. If I don't show decimals then
I wouldn't be having this problem but unfortunately I need the 2 decimal
places.

Juliet Martin


eGroups Sponsor

<http://rd.yahoo.com/M=150967.1016644.2717500.908943/D=egroupmail/S=17000071
83:N/A=468535/*http://ad.doubleclick.net/jump/N1198.egroups.com/B26105;sz=46
8x60;ord=975531549?> click here

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
<http://www.egroups.com/files/vantage/>
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
Thank You!

It was simple and simply overlooked. Thanks so much!

Juliet
At 04:37 PM 11/29/2000 , you wrote:
> >Is there any easy way to suppress zeros in a Report Builder Report on a
> >number that you have formatted with 2 decimals. I am writing an Aged
>Click OFF - "Show at least 1 digit"

I've been trying to figure this one out, too. Unfortunately, the "Show at
least 1 digit" option only chops it from 0.00 down to .00. Trying to use a
format like >>>.>> (no 9's) seems logical, but it won't take it. I've done
an RTFM through the Report Builder User's Guide and skimmed the 4GL books
with no luck yet.

I'd love to hear the trick, but won't be holding my breath :)

-Wayne Cox