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.