Problem with Sub-columns in Cross tab report

[maulae]

Hi There,
I am using Crystal 10 with SQL server db and having problem in creating Cross-tab report. If you give me the solution with Cross-tab or without Cross-tab that would be highly appreciated, here is my problem,
I have five fields in my table’s each row i.e. CompanyName, EmployeeName, Department, Rate, Salary. Each employee may be worked in more than one department up to 5, I want to present this information in such tabular form that’s group by Company then each row’s first column show the employee name and then related department names in 2nd, 3rd, 4th and 5th columns depends how many are the record. Further more I want to divide each department in related employee’s Rate and Salary. I need detail of each record and may be columns summary for salary.

An other forum member Madawc mentioned a mock cross tab report but I am not very much familiar with mock cross tab, can somebody give me some idea how can I do subcolumns, here is the detail what I need.



Company 1
Employee Name Department 1 Department 2 Department 3
Rate Salary Rate Salary Rate Salary

David $30 $800 $35 $900 $25 $700
John $20 $700 $32 $750 $25 $700
Mike $28 $600 $30 $800 $15 $500

In table data all information in same record i.e. CompanyName, EmployeeName, Department, Rate, Salary.
I appreciate your time.

 

[1973kk]

insert a cross tab as follows
select dept for column
Employee name for row
salary and Rate for summary values and select summary type as mode. In the customize tab, from the summerized fields select horizontal