I have a multi select checkbox prompt, which displays Class One of the values in the prompt is NULL so it shows a box with text after it. If the report is executed, after selecting this NULL value explicitly, then it gives error, UDA-SQL-0357.
I changed the Prompt Query, and used NVL( CLASS, '-1' ) to replace the NULL value coming from database. Then in my Report Query filter, I checked for
NVL (CLASS, '-1' ) = ?p_Class?
Now, I do not get any error message, but the report does not display any data.
How do I handle this NULL value selection in Prompt?