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
Report to run with null value or entered value
-
- Posts: 3
- Joined: Tue Nov 13, 2007 7:54 am
- Location: India
-
- Posts: 3
- Joined: Sun Aug 09, 2009 8:58 am
- Location: India
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
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
Who is online
Users browsing this forum: No registered users and 5 guests