Group by two fields in Crystal Reports

How can I group two different fields in Crystal Report?

Game example:

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

I want the report to look like

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

val12
-------
val3|val7

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

val12 :
------
val3|val9
+3
source share
2 answers

The shared data provided is pretty vague, so I will show my own (with field names on the first line)

"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" "" "". , . , "" , , , .

, Crystal Reports 7 .

+6

, , , - ​​ .

, :

MainReportHeader SubReport (?)  SubreportHeader   SubReportFooter MainReportFooter

, , , . , .

0

Source: https://habr.com/ru/post/1698668/


All Articles