BIP Default Null to Select All Parameter
Content
Is there a way to default the value in a LOV to null/blank when you have the option to "select all" in the LOV. Currently, the "All" is defaulted even when I change the order of the SQL statement in the LOV menu, the Parameter "Default Value" column (I know for Sysdate, the syntax is {$sysdate()$} so if there is anything like this) or the report parameter menu. I have not found a way to default null even when I union it in my SQL statement. If anyone knows of a way other than unselecting the "All" ability and moving
Tagged:
0