Overview
Version
| Report Server Version | Functional Change |
|---|---|
11.0 | / |
Expected Effect
In actual applications, you may need to display the queried information on the page in the form of cards. In addition, each card has a form title and a header, and the cards are split by blank rows/columns, as shown in the following figure.
Implementation Method
The row/column split function can help you achieve the card row/column split effect.
Procedure
Data Preparation
Create a template and create a dataset ds1 with the SQL statement Select * from EMPLOYEE.
Template Design
Drag data columns into the corresponding cells, as shown in the following figure.
Each employee card has a form title and a header, and the cards are split by blank rows/columns. In addition, employee cards are sorted and expanded vertically based on the EMPID column.
The following table introduces the cell settings in detail.
| Cell | Setting |
|---|---|
Cell A1 to cell C2 | Merge the area from cell A1 to C2, enter the text Employee Information Survey Form, and set cell B3 to be the left parent cell for the merged cell. |
Cell A3 to cell A6 | Enter text No.:, Name:, Gender:, and Position: respectively in cell A3 to cell A6 and set cell B3 to be the left parent cell for these cells. |
Cell B3 to cell B6 | Drag the corresponding fields into cell B3 to cell B6, respectively, set cell B3 to be the left parent cell of cell B4, cell B5, and cell B6, and set Expansion Direction to Vertical for these cells. Select List from the Data Setting drop-down box under Cell Element > Basic for cell B3. |
Cell C3 to cell C6 | Merge the area from cell C3 to cell C6, drag the corresponding field into the merged cell, set cell B3 to be the left parent cell for the merged cell, and set Expansion Direction to Vertical for the merged cell. |
Cell A7 and cell D1 | Set cell B3 to be the left parent cell of cell A7 (the first cell of blank split rows) and cell D1 (the first cell of blank split columns), since there are split rows and columns between cards. |
Note:
The following figure shows the preview effect. Each card has complete information, with blank split rows between cards.
Row/Column Split Setting
You can view from the above preview effect that the template is vertically expanded. Therefore, select Split by Row in Split Style.
You can view from the above template design that each card occupies seven rows and four columns (including the blank split row at the bottom and the blank split column on the right), rather than six rows and three columns because the title (in the first row) and header (in the first column) in each card are considered as part of the data.
To display four pieces of employee information in each column, you need to set 28 rows per column (7 rows x 4 cards = 28 rows). The exceeded information is displayed in the next column (as cards are expanded vertically), and so on.
Choose Template (on the designer menu bar) > Report Split by Column/Row, select Split by Row and Split Upon Over 28 Row(s) in Split Style, enter A1:D7 in Data to Split: (because the data area to be split is from cell A1 in the top left corner, namely the cell where the form title starts, to cell D7 in the lower right corner), and leave Header Row Sequence: blank (because the title row and header column have already been considered as part of the data to be split), as shown in the following figure.
Effect Preview
PC
Save the template and click Pagination Preview. The effect is the same as that shown in the section "Expected Effect."
Note:Mobile Terminals
The preview effects on the DataAnalyst app and the HTML5 terminals are the same, as shown in the following figure.
Completed Template
Download the template by clicking Card Row (or Column) Split.cpt.
Previous：Column Split based on Result Set Filtering
