| Check Box with Column names [message #286584] |
Sat, 08 December 2007 08:10  |
udaytapal
Messages: 6
Registered: December 2007
Location: Navi Mumbai
|
Junior Member |
|
|
Hi I am Uday,
In search region i have created Check box using below dynamic LOV:
"SELECT DISTINCT COLUMN_NAME D,COLUMN_NAME R
FROM USER_TAB_COLS WHERE TABLE_NAME="EMP"
ORDER BY 1"
With this i got 8 check boxes in search region(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO).
In 2nd region i have created one report based on one select statement (SELECT * FROM EMP).
Now my question is if i click on EMPNO,ENAME check box i would like to show EMPNO,ENAME columns data only, not other columns information.For doing this which steps should i follow.
REGARDS,
Uday.
|
|
|
|
| Re: Check Box with Column names [message #286666 is a reply to message #286584] |
Sun, 09 December 2007 11:29  |
patrick_wolf
Messages: 11
Registered: August 2007
Location: Vienna, Austria
|
Junior Member |
|
|
Add a condition of type "Text in Expression 1 Is Contained in Value of Item in Expression 2" to each of your report columns.
In "Expression 1" you write the name of the column. Eg. EMPNO
In "Expression 2" you write the name of your checkbox page item.
The checkbox page item contains all the selected values as colon delimited list (eg.: EMPNO:ENAME), based on this value the report column is displayed or not.
That should do it
Patrick
Check out my Oracle APEX blog: http://inside-apex.blogspot.com/
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
