Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
.NULL.'s in Reports!
Message
From
28/07/1999 23:02:58
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00246692
Message ID:
00247508
Views:
17
Michael,

SELECT NVL(ValueIfNotNull, '') AS MyValue.....

Or, as Todd said, NullDisplay. One more idea is put something in "Print when".

>Now that VFP6 supports NULL values, I'm finding them in my reports where I'd rather see a blank. Any fix for my report?
>
>The data for the report is derived from a SQL query...
>
>TIA
Previous
Reply
Map
View

Click here to load this message in the networking platform