Heads when needed

[najm]

I have report in which the data is for example is an Emp

when i run the query in a report for a single employe
select * from emp where empno =:ENO;
the results shows

EMPNO ENAME JOB MGR SAL COMM DEPTNO
7499 ALLEN SALESMAN 7698 1600 300 30

EMPNO ENAME JOB MGR SAL COMM DEPTNO
7782 CLARK MANAGER 7839 2450 10

as we know that in the emp query their is some employees have a COMM and many have a NULL value i want in my report when select any employee if he have any commission then it should selected but if they do not have a commission the field show blank as well as it's Heads show also show Blank like this.

EMPNO ENAME JOB MGR SAL DEPTNO
7782 CLARK MANAGER 7839 2450 10
Please let me know the procedure / trigger of it if any one knows

Thanks
Cheers.

[admin]

You can use format triggers in reports. thanks