I. Overview
For online video learning, please see: Cell expansion.
1. Version
| Report server version |
|---|
| 10.0 |
2. Function introduction
Row-based report is the most common and simple report style.
The row-based report extends the data vertically and displays the data as a list form.
II. Examples
1. Data preparation
Create a new data set ds1, write the SQL query statement select * from orders in the database query.
2. Report design
1) Write the table title information in A1-G1 cells, select A1-G1 cells, select cell attributes > style in the right property panel, and select a predefined style in the Style drop-down box to set a head style for the title.
Note: after setting the style of head type, the title font will be automatically centered without additional setting.
2) Drag the relevant data columns in the dataset to cells A2 ~ G2 according to the title field, select cells A2 ~ G2, and center the font.
Note: since cell expansion is vertical expansion by default, dragging data columns into cells in datasets will be vertical expansion by default, and there is no need to set cell expansion properties.
3) Select C2 ~ D2 cells and select cell attributes > style > text in the right property panel. Set the cell format to date > yyyy-MM-dd.
4) Select cell F2, and select Cell Attributes> Style > Text in the properties panel on the right . Set the cell format to Number > #0.00 and keep the value with two decimal places. As shown below:
3. Effect preview
1) PC
Save the report and click pagination preview, the effect is same in I.Overview.
2) Mobile terminal
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
4. Template download
For completed templates, please refer to:
%fr_HOME%\webapps\webroot\WEB-INF\reportlets\doc-EN\ReportDesign\Row-based.cpt
Click to download the template:
III. Typical example index
Please refer to the following table for related report settings commonly used in row reports:
| Subsection | Brief introduction | Documentation link |
|---|---|---|
| Condition property | Add a condition to the property of the report, and when the condition is satisfied, modify the property value of the property, so as to achieve the purpose of changing the report style. | Cells add early warning, interval background color |
| Data filtering | Obtain qualified data from a large amount of data | Filter data - filter |
| Data sorting | When the report is displayed, some data are sorted and displayed more hierarchically | Row report sorting |
| Result set filtering | By setting the result set filter in the high property of the data column to display only N data | Result set filtering |
