Blank zero values in reports?

#1

Using P9.

I've a report continaing several columns of numeric integer values. For
many rows, certain fields will have values of zero. Is there a simple way
to make zero values appear as blanks on the report instead of zeros?

I.E:

Now:
ColName Sept Oct Nov
MyRow1 0 15 9
MyRow2 18 0 6

I want:
ColName Sept Oct Nov
MyRow1 15 9
MyRow2 18 6

TIA,

Karl Perry

#2

Well Tony,

You did beat her with one minut.
But then I think that's because you used less sentences (

)

Pieter Cremers

"Tony McGuire" <tony (AT) paradoxcommunity (DOT) com> schreef in bericht
news:3f043ea9 (AT) jedstarmail (DOT) psfloan.com...

Quote:

There are at least 2 ways.

Scan the table in advance and blank zero values.

In the report, place a calculated field instead of the actual field :

iif([table.field]=0,"",[table.field])

--
--
Tony

"I woke up and was able to get myself out of bed.
Being that fortunate, what's to complain about?"
_____________

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Blank zero values in reports?

comp.databases.paradox comp.databases.paradox

Blank zero values in reports? - 07-03-2003 , 09:20 AM

Re: Blank zero values in reports? - 07-04-2003 , 01:59 AM