提供的通用数据相当模糊,因此我将提供自己的数据进行演示(字段名称位于第一行)
"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 hours
Jane 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。