I. Overview
1. Version
| Report Server Version | Feature Update |
|---|---|
| 10.0 |
2. Preview Effect
Present data in the form of cards in a report, each card has primary title and header, and there are empty rows or empty columns between the cards for division.
3.Solution
Use the column/rows split to achieve a card report.
II. Example
1. Data preparation
Create a new template，and create a new dataset ds1：SELECT * FROM Client
2. Report design
Since each client card includes a primary title and a header, there are empty rows and empty columns between each card to divide, and the client card is vertically expanded according to the "client ID" data column.
| Cells | Setting |
|---|---|
| A1~C1 | Combine cells A1~C1 and enter the text: Client Information. Set the left parent cell to B2. |
| A2~A5 | A2~A5 respectively input text: ID, Name, City, Telephone Number; set the left parent cell to B2. |
| B2~B5 | A2~A5 drag in the corresponding field information, set the left parent cell to B2, and set the expansion direction to vertical expansion. Among them, select List in Cell Element > Basic > Data Setting of B2 |
| C2~C5 | Combine cells C2~C5, drag in the corresponding field information, set the left parent cell to B2, and set the expansion direction to vertical expansion. |
| A6、D1 | There are split rows and columns between the cards. Set the first cell A6 of the split blank row and the left parent cell of the first cell D1 of the split blank column to B2. |
Note: The data setting of the leftmost parent cell needs to be set to "list".
Preview effect as shown below：
3. Column/Rows Split Setting
The preview effect of the above template shows that the template is vertically expanded, so select split by column.
According to the template design that each client information occupies 6 rows and 4 columns (including the card and the blank row below and the blank column on the right)： the first row is the header row, and the first column is the header. The cards have titles and headers, so the size and headings can be regarded as part of the data, so there are 6 rows and 4 columns instead of 5 rows and 3 columns.
If we want to display 5 client information in each column, we need to set 30 rows per column (6 rows * 5 cards = 30 rows), and the excess will be displayed in the next column.
Select Template > Multi-Column/Rows, set to column/row split, when more than 30 rows are divided into columns, the data participating in the column is from A1 in the upper left corner (the cell starting with the title) to D6 in the lower right corner, Therefore, fill in A1:D6 in the column data, because the header has been used as the column data, so the copy row sequence is empty, as shown below：
III. Preview Effect
1. PC
Note: Only pagination preview is supported.
2. HTML5
IV Download Template
Please refer to the completed template: %FR_HOME%\webapps\webroot\WEB-INF\reportlets\doc-EN\Advanced\Card Report.cpt
Click to download the template：Card Report.cpt
