I. Overview
1. Version
| Rreport server version |
|---|
| 10.0 |
2. Application scenarios
Cross-reporting is a common basic report type, and cross-reporting includes both horizontal and vertical expansion of data.
For online video learning, please see: cell expansion.
3. Features
The characteristic of the cross report is that the header is composed of the upper header and the left header. From a formal point of view, it is somewhat similar to a two-dimensional sequence in mathematics, and the data is classified according to rows and columns . The following figure is a typical cross-report, which displays sales data by product, salesperson, and region.
II. Examples
1. Data preparation
Create a new data set DS1, write the SQL query statement select * from sales_basic in the database query.
2. Report design
1) Follow the instructions in the following table to design the table style:
| Cell | Operation |
|---|---|
| A1~D2 | merge A1 ~ D2 cells, write the title of the report "regional sales", set the title to 15 font, bold and center; |
| A3~B3 | merge cells A3 ~ B3, right-click cells, and click cell elements > insert slash. In the pop-up slash edit dialog box, write the field Title: Product|Sales Person|Region ; |
| D3 | write field title: "Total Sales"; |
| A5~B5 | merge cells A5 ~ B5 and write the field title: "Summary:" |
The final table style effect is shown in the following figure:
2) Follow the instructions in the table below to set the cell properties.
| Cell | Operation |
|---|---|
| A4 | vertical expension |
| B4 | vertical expension |
| C3 | horizontal expension |
| C4 | no expension |
| D4 | select cell element > basic > Data Settings > summary > sum in the attribute panel to count the total sales volume of each salesman |
| C5 | sum C4 cells and insert formula =sum (C4) |
| D5 | sum D4 cells and insert formula =sum (D4) |
3. Effect preview
1) PC sideSave the report, clickPagination Preview, the effect is as shown below:
The App has the same effect as the HTML5 side, as shown in the following figure:
For the way to view the report on the mobile terminal, please refer to: Report mobile terminal preview
III. Template download
For completed templates, please refer to:
%fr_HOME%\webapps\webroot\WEB-INF\reportlets\doc-EN\ReportDesign\Cross.cpt
Click to download the template:
