ERPstuff - Oracle EBS Community

Deal All,

My requirement is to display the records based on the parameter value.if we enter parameter value then it should pick only that record if you don't pass any value (NULL) then display all the records.

Please help me out in this issue. Please send me the sample report to naveedapps@gmail.com

Many thanks in advance.



Allah hafeeez,
Naveed

Dear Naveed,
use the nvl clause in your report, like

table.column = nvl(parameter, table.column)

Regards,
Ali Pirzada

Dear Naveed,

This requirement of yours can be done in more than one ways.

1. select * from table where column_name = Nvl(:parameter, column_name)

2. select * from table where (:parameter is null ) <b>OR</b> (column_name = :parameter)

Both of them works. if you have any more share it too.

Best of luck.

Abdul Rahman

Lexical reference is also good to play with parameters. tks