Reporting Service Page Break with respect to Tablix...

Solution: Breaking the Tablix rows based on the Input which is binded with the Report.

Step 1: Add a Tablix and their respective dataset which shows the data as below.

Step 2: right click on the tablix Detail section as shown and select the Add Group Properties in Menu and click the Row Group's -- > Parent Group.

Step 3: add the given Expression in the Parent Group [Fx] -- > "=Ceiling(RowNumber(Nothing) /20) as shown below and press Okay to proceed further.

Step 4: A Group will be created in the Tablix as shown in the screenshot as well as in the below Row Group.

Step 5: Right click the Group Column in the tablix and select the Hidden Property from the Property Window and set the value to "true" as shown below.

Step 6: In the Group Properties, Click on the Page Break tab and set the Page Break Option as "Between Each Instance of a Group" as shown below.



Step 7: Select Sorting tab as shown and delete the Column as shown below.

Step 8: Run the Report below.

Regards

Daniel J.S, BE CSE, MBA Entrepreneur

Data Warehouse and Data Mining Architect,

+91 8939574948...