[SSRs] entry (6)-grouping and total

Through the introduction to [SSRs] (V)-set the report format design, a report in simple format has been generated, such:

This section describes groups and totals:

• Group data by date and order
• Add order total
• Add daily total
• Add total

Group data:

1. Click the Design Option page. (If the "Row group, column group" pane is not displayed, right-click the design drawing and choose "View-> group ".)

2. Drag and Drop the "date" field from the "report data" pane to the "Row group" pane and place it on the (detailed information) Row; the operation method of the "order" field is the same, which is placed between "date" and (details.

3. Preview (the group has been generated, but there are two dates and two order fields ):

4. Set the format as follows:

 

Add order total:

1. Right-click the cell in the "QTY" field and right-click "add total" to add the total quantity of each order:

2. Add "line total", add a label "order total", and set the background color:

3. Preview:

 

Add daily total and report total:

1. Right-click the cell in the "order" field and right-click "add total> later" to add the daily total:

2. The following figure shows the configured image:

3. preview the complete format as follows:

 

In this way, we will complete the grouping and total design.

Next section describes how to publish a report.