locked
How to set number record per page for 6 ? RRS feed

  • Question

  • User1601964810 posted

    I work in rdlc report

    My problem how to set fixed number of records per page to 6 records

    in detail section i have matrix and inside it have rectangle have my data

    matrix have rowgroup inside group i write

    =Ceiling(RowNumber(Nothing) / 2)

    and it have also column group and inside it

    =(RowNumber(Nothing)-1) Mod 2

    my out put result i need

    every page in report

    display 6 record based on two column as following

    1001         1002

    1003        1004

    1005        1006

    my image of report as below

    Sunday, March 12, 2017 11:49 PM

All replies

  • User-2057865890 posted

    Hi Ahmed,

    To fix the number of records per page in the report. Below are the steps.

    1. Navigate to the Rows Groups section and then Details. Select Add Group -> Parent Group -> Choose Expression in Group By (Leave Add group header/Add group footer as unchecked)

    2. Paste the following code into the expression box.
    =CEILING(RowNumber(Nothing)/6)

    3.In the group property navigate to Page Breaks option and select "Between each instance of a group" and leave the other options below unchecked.

    4. By default the added SSRS group also gets added in Tablix column, if you wish not to keep this, you can remove this (Be careful to delete columns only and not the columns and associated groups).

    reference: https://www.mssqltips.com/sqlservertip/3493/display-a-fixed-number-of-rows-per-page-for-an-ssrs-report/

    Best Regards,

    Chris

    Tuesday, March 14, 2017 1:03 AM