I have table structure like
EmployeeName
EmployeeType
EmployeeAddress
EmployeeSalary

And in Table the records inserted in the manner as
Ename      Etype      Eaddress      ESalary
S     Reg.     A1          1000
W     Contr.     A2          1200
E     Reg.     A3          1300
R     Contr.     A4          1225
F     Sal.     A5          1375
H     Reg.     A6          1600

Now I have to show a report group by EmployeeType in the Following format in Crystal Report.

Name     Address          Salary
F     A5               1375

Name     Address          Salary
S     A1               1000
E     A3               1300
H     A6               1600

Name     Address          Salary
W     A2               1200
R     A4               1225



EmployeeType     TotalSalary
Contr.               1375
Reg.               3900
Sal.               2425

Please provide me any solution how I can show the report in Crystal Report. Thanks in advance.


Edited by run4soumya - 23 Aug 2010 at 11:46pm

If your EmployeeType has limited data then you can do it quite easily...