报告设计中的问题 [英] Problem in report designing

问题描述

我正在尝试在水晶报告中设计报告。我从下表中获取数据。

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

使用sql查询我检索了如下结果

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?

推荐答案

您可以使用Crystal Report Cross Tab设计此类报告。

以下链接可能对您有用。



了解Crystal Cross标签 - 第1部分 [ ^ ]

You can use Crystal Report Cross Tab for designing such reports.
Following link may be resourceful for you.

Understanding Crystal Cross Tabs – Part 1[^]

这篇关于报告设计中的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！