Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities

Full Version: Parameter form with static list
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I'm using reports6i, I've a parameter from with a set of parameters in it.
One parameter, Status, has a predifined list of values like 'New','WIP','Completed'.
So i've added these to the List of values for that parameter.
Now i also want to add null in this list, because user may or maynot give value for this parameter, while running the report.
If they want to see records with all these status, then they will not select any of the above mentioned 3 status(ie by default list item will have a null value)

Is there a way to do that?