Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
NULLs in SPT result
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00603525
Message ID:
00603641
Views:
25
snip...
>How about using a UDF call in the report fields that passes the fieldname to a function. Have the function test the value for null. If null, return an empty string. Otherwise, just return the passed value back to the report. This will save you from having to use NVL() in the report fields and let you control all the report output from the function.
>
>In all the report fields:
>
>MyReportUDF(fieldname)
>
>The UDF:
>procedure MyReportUDF
>lparameter tuValue
>if pcount() = 0 or isnull(tuValue)
>   return ''
>endif
>return tuValue
>If you really want to show a blank date, just check the vartype of tuValue and return {} of null dates.

There are too many reports to do that on (over 50) that's why we controlled the data for the reports on the report generator.

...

Yeay! Finally fixed it. Forgot to reference the correct array row (it was always pointing to the first two elements instead of the first two columns).
I coudn't see it until one of the guys here pointed it out.

Thanks,
Arriyel
Speak using soft and sweet words in case you have to eat them later.
Previous
Reply
Map
View

Click here to load this message in the networking platform