Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remove null values from cursor
Message
From
08/07/2007 11:17:20
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, United States
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01238444
Message ID:
01238460
Views:
9
Marcel,

You can use SET NULLDISPLAY TO "". This is scoped to the datasession for your report.

>This question has probably been asked many times.
>
>Creating a report after combining two cursors. One of the fields ends up with a lot of null values. (using select with join into cursorname)
>
>What's an efficient way to remove those null values from preview and report? I tried in "print object when" field ! isnull(cursorname.fieldname) That apparently doesn't work though.
>
>Thanks in advance!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform