Hello, I am using a Tablix in one of my SQL Reporting services report. Default view shows up all records. I want to implement Paging like show up first 50 records in page 1 and next 50 records in page 2 and so on. Can someone help me with this?

Hi There, Here's what you can try doing: Select the tablix control. In the Properties window, choose the correct dataset name in the DataSetName property.In the Row Groups Pane, right Click "Details" and select Group PropertiesIn the Group Properties window, click "Add" button. Then specify the expression in the Group on textbox. =ROWNUMBER(Nothing)/50 4. To set page breaks between groups, select Page Breaks in the left menu, check Between each instance of a group. Then click OK. Please feel free to ask for more info. if required. HTH. Cheers, IceQBPlease mark correct answers :)

With the mentioned steps now I'm getting one row per page. It's still not displaying 50 records in one page.

Hi Got, Thanks for your posting.Based on your scenario, we can use the conditional page break to achieve the requirement. Please 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(rownumber(nothing) mod 50=0,false,true) The screenshot below is for your reference: Regards, Charlie Liao

Ah! Great solution Charlie! Cheers, IceQBPlease mark correct answers :)

Thanks Charlie. That worked but I'm not able to retain Column Headers other than 1st page even after setting RepeatColumnHeader = TRUE. Any Ideas? I'm using sql 2008 r2 version.

Hi Got, Please refer to the steps below to achieve your requirement: In the Grouping pane, click the arrow that appears to the right of the Column Groups label, and click Advanced Mode to display all groups.In the Roe Groups section, click the first Static group, and then, in the Properties window, in the RepeatOnNewPage drop-down list, select True. The screenshot below are for your reference: Please feel free to ask if you have anything unclear. Regards, Charlie Liao