Problem in report designing

See more:

ASP.NET

CrystalReports

I am trying to design a report in crystal reports. I am fetching data from following table.

Id int,
CompanyName varchar,
NoOfEmployees int,
DeptId int,
Status char

Now I want to display Department wise number of employee for each company.

The report should display something like below

            Admin        Sales         Development       Support
Company 1      5            12                  22            15
Company 2      4             9                  35            19
Company 3      5            13                  29            10

Using sql query I have retrieved the result as follows

Company 1  Admin         5
Company 1  Sales        12
Company 1  Developement 22
Company 1  Support      15

and so on.


Now how can I display the above result as per required format?