I. Overview
1. Version
Report server version |
---|
10.0 |
2 Expected effect
An aggregated report refers to a report that contains multiple modules, each of which is similar to a separate report or a chart, and blocks are relatively independent and do not affect each other. Embedded subreports can only be displayed in a fixed size area and cannot be automatically expanded. If an Embedded main sub-table is used to make a template, the sub-report is relatively large and has more than one page. At this time, only part of the sub-report is embedded in the main report.
In fact, the subreport needs to display all the data, or the two extended cell settings do not affect each other, as shown in the following figure:
3. Solutions
This can be achieved using aggregated reports.
II. Example
1. Create a new report
1) Create a new aggregate report, create a new built-in data set, select Table Design, click Add, and add the corresponding columns according to the requirements, as shown in the following figure:
2) Three new built-in datasets, Production, Main engine production table, and Raw materials entering and consumption, are shown in the following figure:
2. Report Design
1) In the newly created aggregate report, drag and drop four report blocks, the size of the module does not need to be fixed, it can be the same size as the design template, as shown in the following figure:
2) Click on the first report block, the cell settings in the report block are shown in the following table:
Cell | content |
---|---|
A1~J1 | Merge cells A1~J1, insert the text in the cell: Cement production comprehensive daily, set the font color to Green, Center |
A2 | Insert text in cell: Reporting unit: |
B2 | Insert text in cell: product security office |
D2 | Insert text in cell: Reporting date: |
E2 | Insert a formula in a cell:today() |
H2~J2 | Merge cells H2~J2 and insert the text in the cell: Unit: ton, %, Kwh |
After the report block is set, the effect is shown in the following figure:
3) Click on the second report block, the cell settings in the report block are shown in the following table:
Cell | content |
---|---|
A1, B1 | Merge cells A1 and B1, insert text in the cell: Production, set the font toLeft"and Bold |
A2, A3 | Merge cells A2 and A3, insert text in the cells: Statistical dimension, set the style to Follow theme, select the Head2 style, set the font to Center, and set the expansion method to Do not expand |
A4 | Drag the Situation data column in the Production Table dataset into the A4 cell, the expansion method is Vertical Expansion, and the left parent cell and the upper parent cell are Default |
B2 | Drag the Production data column in the Main engine production table dataset into cell B2, the expansion method isHorizontal expansion, the left parent cell and the upper parent cell are default, and the font is set tobold |
B3 | Drag theMachinesName data column in the Main engine production table dataset into cell B3, the expansion method is Horizontal expansion, and the left parent cell and the upper parent cell are default |
B4 | Drag theVolume data column in the Main engine production table dataset into cell B4, |
After the report block is set, the effect is shown in the following figure:
4) Click the third report block, the cell settings in the report block are shown in the following table:
Cell | content |
---|---|
A1, B1 | Merge cells A1 and B1, and insert the text in the cell: Raw materials entering and consumption, the font is set toLeft, Bold |
A2 | Insert text into the cell: Statistical , set the style toFollow theme, select theHead2style, set the font to Center, and set the expansion method toDo not expand |
A3 | Drag the Inventory data column in theRaw materials entering and consumptiondataset into cell A3, the expansion method is Vertical Expansion, and the left parent cell and the upper parent cell areDefault |
B2 | Drag the MaterialNamedata column in the Raw materials entering and consumption dataset into cell B2, set the style to Follow the theme, select the Head2style, and set the font to Center, Bold, the expansion method is Horizontal expansion, and the left parent cell and the upper parent cell are default |
B3 | Drag the Stockdata column in the Raw materials entering and consumption dataset into cell B3, the expansion method is Horizontal expansion, and the left parent cell and the upper parent cell aredefault |
After the report block is set, the effect is shown in the following figure:
5) Click the fourth report block, the cell settings in the report block are shown in the following table:
Cell | content |
---|---|
A1~B1 | Merge cells A1 and B1, insert the text in the cell: Main engine production table, set the font toLeft and Bold |
A2 | Insert text into the cell: Statistical dimension, set the style to Follow theme, select the Head2 style, set the font to Center, and set the expansion method to Do not expand |
A3 | Drag the Production data column in the Main engine production table dataset into the A3 cell, the expansion method is Vertical Expansion, and the left parent cell and the upper parent cell are Default |
B2 | Drag the MachineName data column in the Main engine production table dataset into cell B2, set the style toFollow the theme, select the Head2style, set the font to Center, Bold, and expand the method It is Horizontal expansion, and the left parent and upper parent are Default |
B3 | Drag the Volume data column in the Main engine production table data set into cell B3, the expansion method is Horizontal expansion, and the left parent cell and the upper parent cell are Default |
After the report block is set, the effect is shown in the following figure:
6) Click the fourth report block, the cell settings in the report block are as shown in the following table:
Cell | content |
---|---|
H1 | Insert text in cell: Reviewed : with font set to Right |
I1 | Insert text in cell: Manager Yang |
J1 | Insert text in cell: Date : with font set to Right |
K1 | Insert a formula in a cell:today() |
After the report block is set, the effect is shown in the following figure:
3. Page Setup
Adjust the column width of the report block according to the page requirements, click Template > Page Setup, check Predefined to set the paper size to A3, as shown in the following figure:
4. Effect preview
1) pagination preview
Save the template, click Pagination Preview, and the aggregate block will expand the data automatically. If the size exceeds one page, it will be displayed in page, as shown in the following figure:
2) Data analysis preview
Save the template, click data analysis preview, and the aggregate block will automatically expand the data, and the data will be displayed on one page, as shown in the figure below:
Note 1: Aggregated reports do not support mobile terminals.
Note 2: The aggregated report does not support fill-in preview.
Note 3: Aggregated reports do not support freezing.
III. Template download
For completed templates, please refer to:
%fr_HOME%\webapps\webroot\WEB-INF\reportlets\doc-EN\ReportApplication\BasicApplication\
Aggregation.cpt
Click to download the template: