SSRS - Adding Page Break

To add page break to a large result set: 

In your scenario, you want to display 10 records in each page, we can achieve it follow the steps below.

1. Click the Details group in the Row Groups pane.
2. From the Tablix member Properties pane, expand “Group”-> “PageBreak”.
3. Set the “BreakLocation” to “End” and set the “Disable” property to the expression like below:  =IIF(Globals!RenderFormat.Name = nothing, IIF((rownumber(nothing) mod 30) = 0,false,true), true)  NOTE: this expression disable pagebreak when exporting.

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/276acd62-49e7-41ad-a50e-7e4b97e44dcc/tablix-paging-in-ssrs