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, form titles and headers exist in each card which is 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 named ds1. The SQL statement is select * from Employee.
Template Design
Drag data columns into the corresponding cells, as shown in the following figure.
Employee cards (sorted and expanded vertically based on the Employee ID column) can be split by blank rows and columns between each card (in which the title and header are included).
The following table introduces the cell setting 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. |
Cell A3 to Cell A6 | Enter texts No.:, Name:, Gender:, and Position: respectively in cell A3 to cell A6 and set cell B3 to be the left parent cell. |
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. Select List from the drop-down list of Data Setting 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 area, set cell B3 to be the left parent cell, and set Expansion Direction to Vertical. |
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 exist 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.
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 * 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 Rows 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 enter nothing in Header Row Sequence (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 Display
On PC
Save the template and click Pagination Preview. The effect is the same as that shown in section "Expected Effect."
Note:
On Mobile Terminals
The preview effect on the DataAnalyst app and in HTML5 are same, as shown in the following figure.
Template Download
You can download the template Card Row (or Column) Split.cpt.
Previous：Column split by result filter
