Successfully!

Error!

Paginate By Group

  • Last update:  2020-12-03
  • I. Overview

    1) After inserting data columns into cells and setting expansion, the expanded data may exceed the page size. In pagination preview mode, FineReport will split the data beyond the page size to the next page, but this will cause the same group of data to be displayed on different pages. Even if the data column does not exceed the page size, it will exceed the browser window size when previewing, so users cannot view the data intuitively.

    2) Through pagination settings, each page can only display the same set of data, making the data display more beautiful. Pagination settings can control the location of pagination, break and pagination repetition.

    3) Prerequisite:Horizontal and Vertical Cell Expansion and Left Parent Cell and Upper Parent Cell.

    You will learn
    • Paginate After Row, Paginate Before Row

    • Can Break On Paginate, Repeat Content When Paging

    II. Paginate After Row, Paginate Before Row

    1. Create a new dataset [ds1]

    1) Create a new DB query dataset.

    2) Drag the table [Sales_Volume] into the DB query.


    2. Drag data columns into cells.

    1) Drag all data columns of [ds1] into cells B3~F3.

    2) By default, all data columns expand vertically. B3 is the parent cell of C3, C3 is the parent cell of D3, and so on.

    3) Input data column names in B2~F2.

    4) B2~F3: Set as center alignment and add borders. B2~F2: fill the cells with gray.

     

    5) Preview. The data is displayed in groups due to Expand Direction and Parent Cell settings. But the data is too much to fit the size of the browser window.


    3. Paginate After Row – Paginate by Region

    1) Select B3. Check [Paginate After Row]. The dotted line is the page break.

    2) Preview. Only the data of the same region is displayed on each page.


    4. Paginate After Row – Paginate by Salesperson

    1) B3: Uncheck [Paginate After Row].

    2) C3: Check [Paginate After Row].

    3) Preview. Only the data of the same salesperson is displayed on each page.


    5. Paginate After Row – Set Duplicate Title Rows

    1) Press and hold the Shift key to select the first and second rows, right click and select [Set Duplicate Title Rows].

    2) (H) appears after each row number, indicating the rows have been set as duplicate title rows.

    3) Preview. The title row is repeated on each page.


    6. Paginate Before Row – Paginate by Region

    1) C3: Uncheck [Paginate After Row].

    2) B1:

    a. Left Parent Cell: Custom, select B3

    b. Check [Paginate Before Row]

    3) Preview. Only the data of the same region is displayed on each page.


    7. Paginate Before Row – Paginate by Salesperson

    1) Left Parent Cell of B1: B3.

    2) Right Click Column B and select [Hide].

    3) Preview. Only the data of the same salesperson is displayed on each page.

    III. Can Break On Paginate, Repeat Content When Paging

    1. Merge cells A1~H1


    2. Input the following text in A1

    FineReport is a “professional, easy-to-use and flexible” enterprise reporting software developed by FanRuan Software Co., Ltd, architecturally designed based on “no-code development” concept. With FineReport, users can quickly design complex reports and good-looking dashboards by dragging and dropping report elements and incorporates reports and dashboards to establish a decision-making platform. FineReport is the leading reporting software in China with the highest domestic market share and widespread clients from various industries and departments.


    3. Default: Can Break On Paginate, Repeat Content When Paging.


    4. Preview.

    Both the first and second pages display the text in A1.


    5. Uncheck [Repeat Content When Paging]


    6. Preview

    The second page only displays the part not displayed on the first page.


    7. Uncheck [Can Break On Paginate]


    8. Preview

    The content in A1 is completely displayed on the first page.

    Attachment List


    Theme: Report Application
    • Helpful
    • Not helpful
    • Only read

    Doc Feedback