I. Overview
1) When the report data need to be displayed in multiple pages and the title rows and footer rows need to keep unchanged in each page, you can use the function of duplicate to make header rows and footer rows appear in each page.
2) When there are a large number of rows in a report, scrolling down to view all data will make the header rows no longer display. You can use the function of freeze to fix the header rows. In this way, the header rows can keep visible when scrolling down to view more data.
| You will learn |
|---|
|
II. Steps
1. Create a new dataset [ds1]
1) Create a new DB query dataset.
2) Drag the table [Product] into the DB query.
2. Design a report
1) Drag data columns into cells B3~F3.
2) Merge B2~F2 and input a title.
3) Merge B4~F4 and input a footer.
4) Set borders, background color and text color for the cells.
3. Pagination preview
The title row is only visible on the first page and the footer on the last page.
4. Set Duplicate Title Rows and Last Row
1) Click Template->Duplicate and Freeze to open the settings panel.
2) Check Duplicate Title Rows and set the range of title rows to [From No.1 Row to No.2 Row].
3) Check Duplicate Last Row and set the range of last row to [From No.4 Row to No.4 Row].
5. Effects after setting duplicate rows
1) The row number of the duplicate title row will be followed by (H).
2) The row number of the duplicate last row will be followed by (F).
6. Pagination preview
The title and footer are displayed on each page.
7. Shortcuts to set duplicate title rows and end rows
1) Press and hold Shift to select the title row, right click and select Set Duplicate Title Rows.
2) Press and hold Shift to select the end row, right click and select Set Duplicate End Rows.
8. Set freeze title rows – Pagination Freeze
1) Check Freeze No.1 Row to No.2 Row, and the system has automatically identified the range of duplicate title rows as Rows 1-2.
2) When setting Pagination Freeze, please set duplicate title rows first before setting freeze title rows.
9. Pagination preview
Scroll down and the title row is frozen and always visible.
10. Insert [Text Widget] into B3~F3 to change the pagination report to a data entry report
11. Freeze – Data Entry Freeze
1) Check and set Freeze No.1 Row to No.2 Row.
2) When setting Data Entry Freeze, it is not required to check [Duplicate Title Rows From No.1 Row to No.2 Row].
12. Data entry preview
Scroll down and the title row is frozen and always visible.
