Fastreport.net using: [4] Grouping

1. Draw the report title and the top of the column.

2. Set up the report bar to add a group to the data area

3. Right-click the group header and select Edit in its right-click menu to display the Group Edit dialog box.

Set the grouping criteria, you can select the "study number" column in table tables directly from the drop-down menu, or you can go to the Expression Edit dialog box via the FX expression button and select the "study number" column in the tables table in the data source of the Expression Editing dialog box.

4. Add a Label control to the grouping header bar to display the grouping information.

Sets the background color of the label control to Lightgray.

Double-click the Label control to enter the text editor with the following: Name: [table. Name] (Study No.: [Table. Study number]). The brackets are the columns in the data source, and the others are plain text.

5. Add the "account number" and "Account name" columns in the data area.

6. Set the group footer to display the number of accounts for each student's selected course.

Drag and drop a label control into the grouped footer bar, and make the related property settings.

Add a total. Right-click Totals, select the New Totals menu, display the Summary Item Editor dialog box, set the formula to count, and choose a print position of GroupFooter1: study number.

Double-click the Label control in the group footer bar to enter the text editor and select the number of lessons: [Total]

7. Finally, the contents and height of each column of the report are set appropriately, then a beautiful report is obtained.

Fastreport.net using: [4] Grouping