crystal-reports - 在 Crystal Reports 中按两个字段分组

Question

如何在 Crystal Report 中按两个不同的字段分组？

敌人的例子:

val1|val2|val3|val6
val1|val12|val3|val7
val11|val2|val3|val8
val11|val12|val3|val9

我希望报告看起来像

val1 :
=======
val2 
----
val3|val6

val12
-------
val3|val7

val11  :
=========
val2
-----
val3|val8

val12 :
------
val3|val9

Answer 1

提供的通用数据比较模糊，所以我会提供自己的来演示(字段名称在第一行)

"EmployeeName","WeekNumber","DayOfWeek","HoursWorked""John Doe",20,"Monday",8"John Doe",20,"Tuesday",8"John Doe",20,"Wednesday",8"John Doe",21,"Thursday",8"John Doe",21,"Friday",8"Jane Doe",20,"Monday",8"Jane Doe",20,"Tuesday",8"Jane Doe",21,"Wednesday",8"Jane Doe",21,"Thursday",8"Jane Doe",21,"Friday",8

假设我没看错问题，你会希望报告看起来像这样:

John Doe   Week: 20      Monday       8 hours      Tuesday      8 hours      Wednesday    8 hours   Week: 21      Thursday     8 hours      Friday       8 hoursJane Doe   Week: 20      Monday       8 hours      Tuesday      8 hours   Week: 21      Wednesday    8 hours      Thursday     8 hours      Friday       8 hours

如果是这种情况，您将首先按“EmployeeName”字段分组，然后使用“分组”选项通过“插入”菜单简单地为“WeekNumber”添加另一个分组。这非常简单，您可以对各个级别的字段进行汇总。如果您正在计算组内的字段并希望将这些计算返回到更高级别的分组以进行求和，那么多层分组唯一会变得“毛茸茸”，这需要在报告中声明全局变量。

不管怎样，在过去的 7 年里，我一直在大量使用 Crystal Reports。