Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Suppress printing of .NULL.
Message
From
10/06/1999 13:27:15
Ken Mears
Calif Dept of Fish & Game
Sacramento, California, United States
 
 
To
09/06/1999 20:03:31
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00228192
Message ID:
00228490
Views:
13
>It can be done in two places. First, you can get rid of NULLS in view. In SELECT part of the view you can use IIF(!ISNULL(fieldname), fieldname, "") AS fieldname. You wont have any NULLS in view then. Second, in report itself. If you dblclick on a field you will see 'Print when'. Say !ISNULL(fieldname).
>HTH Mark

Thanks for the suggestions, I chose the !ISNULL and it works great. I knew it was under something besides just .NULL.
Ken
Ken Mears
Previous
Reply
Map
View

Click here to load this message in the networking platform