Sql Server & SSRS Tips

If you want to change pages when a group value changes(adding page breaks on group values ). then select group from bottom and right click on it and go  to group properties. select page break option from the left options. and then checked the box named"between each instance of a group"....this will add page break againt changing of group value....set its child properties according to your need.

I had faced the similar problem while using Tablix in SSRS 2008. I had a simple table with no groups in it. I need to repeat the Row Headers on each page. I overcomed the problem by selecting the tablix, below you would be able to see the groups: Row Groups and Column Groups. Besides the Column Groups there is a small triangle. Click on it and you will be able to see the Advanced Mode Properties. If there is no group on your tablix, under the Row Groups Section, Above the Details you will be able to see a "Static" Row Section. Select that Static section and go to the Properties window. Change three properties: 1) Fixed Data = True 2) Keep with group = After 3) Repeat on new page = True By this you are done with the Row Headers on each page.