Parameter in Discoverer

[vamsioracle]

Hi all


I need logic to implement the following
I have a discoverer report where in i have a param and an lov attached to it. I want All to be included in the LOV and when i click all , i want the report for all the values in the list.
how can i do this


thanks
vamsi

[amitpatel66]

You will need to create some filter conditions that can refer to this LOV and if it equals "ALL" then select all the values from the table and place it in the IN LIST of the query