Skip to Content
0
Oct 05, 2009 at 05:28 PM

Adding empty values to the XLR syntax

20 Views

Hello,

We have a UDF, linked to a UDT, on documents row level that we then us in XL Report.

The XL report is designed to include u2018*u2019 and u2018NULLu2019 for this field.

The problem is that whenever you stand / pass this field (even using Tab) the value in the SQL is changed from NULL to Empty (u2018 u2019) and then the XLR doesnu2019t consider this.

I have 2 questions:

1. Is it possible to add also empty values to the XLR syntax?

2. Is it possible to somehow leave the Null default value in SQL (except for FS that enters the value NULL as default)?

Thank you,

Maya