Printing .NULL

--- This post is also appears in printing forum and is reposted here to
ensure best exposure ---

In my reports null values appear as .NULL.

I would like to have them appear as something like --- or another N/A-style
indicator.

Some of these fields also have expressions already defined such as the one
below:

IIF(PartNumber = "V","---",ItemType)

So the solution would have to be incorporated or work around existing
expressions.

ANYTHING other than .NULL would be great at this point!

Thank you.

Alan

Fred
Thu Jan 01 15:41:34 CST 2004

Not sure if SET NULLDISPLAY would work for a report or not.

If it doesn't, you could change your fields to be an expression like this:

IIF(ISNULL(PartNumber),"(none)",IIF(PartNumber = "V","---",ItemType))

Fred
Microsoft Visual FoxPro MVP

"Citizens' Arrayst" <nospam@microsoft.com> wrote in message
news:uLkFtJI0DHA.1688@TK2MSFTNGP10.phx.gbl...
> --- This post is also appears in printing forum and is reposted here to
> ensure best exposure ---
>
> In my reports null values appear as .NULL.
>
> I would like to have them appear as something like --- or another
N/A-style
> indicator.
>
> Some of these fields also have expressions already defined such as the one
> below:
>
> IIF(PartNumber = "V","---",ItemType)
>
> So the solution would have to be incorporated or work around existing
> expressions.
>
> ANYTHING other than .NULL would be great at this point!
>
> Thank you.
>
> Alan
>
>

Cindy
Thu Jan 01 21:09:28 CST 2004

In news: uLkFtJI0DHA.1688@TK2MSFTNGP10.phx.gbl,
Citizens' Arrayst <nospam@microsoft.com> wrote:
> --- This post is also appears in printing forum and is reposted here
> to ensure best exposure ---

Hi Alan,

Please see my answer in the reports.printing newsgroup.

If you want to post in more than one group it's best to cross-post rather
than posting individual times. Answers to cross-posted messages show up in
all the groups so the thread is kept together. I'd also like to point out
that most of us who read and post here read all the Fox newsgroups so your
post will be seen wherever it is.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@mvps.org www.cindywinegarden.com

Nasib_Kalsi
Fri Jan 02 00:12:00 CST 2004

Which version of Foxpro/dBase do you have ?

>-----Original Message-----
>--- This post is also appears in printing forum and is
reposted here to
>ensure best exposure ---
>
>In my reports null values appear as .NULL.
>
>I would like to have them appear as something like --- or
another N/A-style
>indicator.
>
>Some of these fields also have expressions already
defined such as the one
>below:
>
>IIF(PartNumber = "V","---",ItemType)
>
>So the solution would have to be incorporated or work
around existing
>expressions.
>
>ANYTHING other than .NULL would be great at this point!
>
>Thank you.
>
>Alan
>
>
>.
>