Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
.NULL. showing on my reports
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00452174
Message ID:
00452219
Views:
20
>Hi all,
> I finally figured out how to do a left outer join but in the fields with no match I have .NULL. showing in my report column. There must be a simple way to remove it but I haven't worked with nulls before.
>
>
>Many thanks in advance to all the helpfull people at this site.

John, you can put
NOT ISNULL(myfield)
into Print When condition for the report field.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform