Display all record in case of null parameter OR selecting "ALL"
443251Feb 4 2009 — edited Feb 4 2009hi all,
I want to show the all records in the report in case the user give empty parameter Or "ALL" from the parameter list.
I used such the way in the query:
select item
from item_master
where ITEM_ID = NVL(:P_ITEM,ITEM_ID);
its working good but now I want to give the "ALL" in the list of parameter form. so when the user select the "ALL" then the all items to be displayed.
thanks
Muhammad Nadeem
nadeem14375@gmail.com