| How to create value set [message #474003] |
Wed, 01 September 2010 23:56  |
yknev
Messages: 38
Registered: August 2010
|
Member |
|
|
Hi All,
I would like to create a report with Parameters. I have doubt on creation of Parameter while registering of report. Could hlep me..
My code:-
SQL> select * from table1;
SINO VNAME SAL ISS_DT
---------- ---------- ---------- ---------
5 ANTONY 02-SEP-10
1 SMITH 1000 01-JAN-10
2 ALLEN 2000 01-FEB-10
1 LION 2000 26-JAN-10
3 TIGER 4000 15-MAR-10
VISION 4000 13-MAR-10
3 VISION 2000 10-SEP-09
7 rows selected.
SQL> select * from table1
2 where iss_dt>='21-JAN-2010';
SINO VNAME SAL ISS_DT
---------- ---------- ---------- ---------
5 ANTONY 02-SEP-10
2 ALLEN 2000 01-FEB-10
1 LION 2000 26-JAN-10
3 TIGER 4000 15-MAR-10
VISION 4000 13-MAR-10
SQL> select * from table1
2 where iss_dt>='21-JAN-2010'
3 and sal is not null;
SINO VNAME SAL ISS_DT
---------- ---------- ---------- ---------
2 ALLEN 2000 01-FEB-10
1 LION 2000 26-JAN-10
3 TIGER 4000 15-MAR-10
VISION 4000 13-MAR-10
SQL> select * from table1
2 where iss_dt>='21-JAN-2010'
3 and sal is not null
4 and sino is not null;
SINO VNAME SAL ISS_DT
---------- ---------- ---------- ---------
2 ALLEN 2000 01-FEB-10
1 LION 2000 26-JAN-10
3 TIGER 4000 15-MAR-10
Now, i want to create one parameter with List of values(LOV)like
Parameter Name:- SAL
List of Values:- ALL (i want to execute upto:- iss_dt>='21-JAN-2010')
SAL (I want to execute upto:- and sal is not null)
SINO(my quey execute upto:- FULL Query|)
How to create the Parameters using above conditions. Please help me.
Regards,
Yknev.
|
|
|
|
| Re: How to create value set [message #474041 is a reply to message #474003] |
Thu, 02 September 2010 04:26  |
 |
Alien
Messages: 292
Registered: June 1999
|
Senior Member |
|
|
Hi,
What exactly is the question? Do you want to know how to create a value set to be used in the parameter.
Or do you want to create a query that has a where clause dependent on the value of a parameter?
For the first one, create a value set (system administrator/application/flexvield/validation) with type independent. And enter the ALL, SAL, SINO in the values form.
Then in your report, you can use something like: select .... from .... where (:Param = 'ALL') or (:param = 'SAL' and sal is not null) or (:param = 'SINO' and sal is not null and sino is not null)
Regards,
Arian
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
