We are having an issue with BI Publisher prompts where a small handful of columns from SQL, when used as prompts, are appending and defaulting the string 'All' to the column values.
I have a Report where two seemingly similar columns/prompts are behaving in two different ways (Geomarket is behaving correctly)...
The SQL for the List of Values are both the same format - select distinct COLUMN from TABLE - and 'All' is not a value in the column representing High School.
Both DB columns are of type VARCHAR2.
Both Parameters are set up to point to their respective LOVs, but are otherwise identical...
The impact of this is that an optional prompt such as High School will require the user to switch the value from the string 'All' (or whatever arbitrary string we choose) to the 'All' that represents All Column Values. In many cases optional prompts are rarely touched, so to require a user to change the value every time would be challenging.
Any thoughts? We would appreciate any input.