Last post Mar 14, 2017 01:03 AM by Chris Zhao
Mar 12, 2017 11:49 PM|ahmed.barbary|LINK
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
my image of report as below
Mar 14, 2017 01:03 AM|Chris Zhao|LINK
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.
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).