Help - Cross Tab Report

[mithilwane]

Hi,

I need to make a cross tab report for salary.

In the Rows I need Employee Code. That I have got figured out.

But in the Column section I have 2 different Columns From table. Employee name and Salary component as Columns.

The Database Query I fire shows me data like below.

EMP CODE          EMPLOYEE NAME          SALARYCOMPONENT TYPE          SALARY AMT

1                             MITHIL WANE                  BASIC                                                  2000

1                             MITHIL WANE                  HRA                                                     1000

2                             MIKE                                  BASIC                                                  3000

2                             MIKE                                  HRA                                                     1500

[mithilwane]

Got how to do this. For this we need to have 2 Row Groups and change the second row group height to 0 manually so that it doesnt show.