Shulou(Shulou.com)06/03 Report--

When you walk into the convenience store, you will find that all the goods are discharged by category, classified emissions can help you quickly find similar products, but also quickly find the goods you want.

When you go to a restaurant, the dishes on the menu are also arranged by category, such as cold dishes, hot dishes, soups, staples and so on. When you order, you will turn directly to the kind of menu you want and order.

……

Through the above scenario, we can understand the benefits of grouping to present data. Grouping can help quickly locate, facilitate data search, summary, analysis of data trends, and so on. Sometimes it is worthless to analyze a single commodity, so grouping is the most common and simplest means of data analysis.

Grouping report uses the grouping function in the report, which is the most commonly used report type in the work. The grouping function may form a separate report, or it may be combined with other functions to form a complex function report.

In the grape city report, you can set single-level grouping and nested grouping. At the same time, you can also use data area controls such as tables, lists and matrices to group data sources.

What is a grouped report

Grouped report is the most basic and common report type of all reports, and it is also the report format supported by all report tools. Generally speaking, a grouping report is a vertical grouping. The traditional way of making grouping report is to divide the report into stripes, and the user specifies the grouping, summarizing the fields and generating the standard grouping report according to a data binding wizard. Of course, we can also make grouping reports in Excel, but this can only be implemented on the premise of a small amount of data. When the amount of data is very large and complex, I believe that using Excel to make grouping reports will get twice the result with half the effort.

Types of grouped reports

Grouping reports can be divided into single-level grouping and more complex nested grouping. Single-level grouping is the most basic grouping report, such as commodity information by category.

Nested grouping is multi-level grouping, such as sales report contains three layers of nested grouping statistics, first grouped according to sales month, then grouped according to product category, and finally counted according to product name, and calculated according to product category and sales month.

Whether it is single-level grouping or nested grouping, grouping data needs to be presented by carriers, and data area controls such as tables, lists and moment tables are the carriers for grouping operations. The following figure shows a tabular report grouped by rows of regions and columns of months.

Application of grouping report

It can be said that group report is the most common report type, and there are numerous applications of group report in business report system, such as customer information classification statistics, commodity classification statistics, annual sales records statistics, reading statistics, personnel group statistics and so on. Grouped reports are widely used, and even there are grouped reports in every report system.

Procedure:

1. Create a new RDL report

two。 Connect to the data source

3. Create a new dataset

Enter the database query statement:

SELECT order. Order ID, strftime ('% yearly, order. Order date) AS ordering year, strftime ('% masked, order. Order date) AS order month, category. Category name, category. Description, product. Product name, order details. Quantity, order details. Unit price, order details. Discount FROM (order

INNER JOIN order details ON order. Order ID = order details. Order ID)

ON order details of INNER JOIN products. Product ID = product. Product ID)

INNER JOIN category ON products. Category ID = category. Category ID

WHERE strftime ('% yearly, order. Order date) = '2012'

ORDER BY ordering year, ordering month, category. Category ID, order details. Product ID

4. Add table controls to set the basic layout

4.1 add table controls to the design interface

4.2 add form 1 level grouping

Select the table detail data row, right-click, and select insert grouping

In the table-grouping editor, enter the expression: = [order month]. After clicking OK, the table will generate [1]

4.2 insert Table 2 level grouping

Click the [+] symbol in the table-grouping window and enter the grouping expression: = [category name]

Add the grouping effect

4.3 add 5 columns to the right of the table

4.4 add a header row, close the header cell in the first row, and enter the title [= [year of ordering] & "Annual monthly sales report-detail pages"]

4.5 in the first line of group 1-group, merge the cells and enter = [ordering year] & "year" & [ordering month] & "month"

4.6 in the group 2-group header line, merge the remaining cells and enter = [category name]

4.7 in the detailed data area, bind specific fields

4.8 in group 2-tail line, enter the total: = Sum ([quantity] * [unit price] * (1-[discount]))

The basic setting of the table style is complete.

5. Preview

Reprint please indicate from: grape city report

About the report of Grape City

Grape City report is a powerful report development and system building tool, which can not only be closely integrated with your report software project, but also can be deployed and run independently. It supports multiple data sources and has the characteristics of no coding, flexibility and stability. It can help you quickly build a professional report software system to achieve the design, management, authority control, data filling, load balancing and cross-platform release of all kinds of reports.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.