How to Add Manual check box and Check all check box in a grid

How to Add Manual check box and Check all check box in a grid

Step 1 : Add check box in a classic report :

Take a classical report and go the query source and type the query as the following way so that there is a column of checkbox

SELECT 
       EMPNO,
       apex_item.checkbox(1,EMPNO,'UNCHECKED') as Checkbox,
       ENAME,SAL,
       JOB,
       HIREDATE
FROM 
       EMP

SELECT

EMPNO,

apex_item.checkbox(1,EMPNO,'UNCHECKED') as Checkbox,

ENAME,SAL,

JOB,

HIREDATE

FROM

EMP

Step 2 : Checking all check box :

Go to column header of “Checkbox” column and type the header text as under:

<input type ="checkbox" onclick="$f_CheckFirstColumn(this)"/>

1	<input type ="checkbox" onclick="$f_CheckFirstColumn(this)"/>

Now Apply changes, run the page and test the changes by checking the checkbox.

Thank You

Comments are closed.