1) How to make header to repeat in each page for tabular report.
Solution can be found at http://www.sqlchick.com/entries/2011/8/20/repeating-column-headers-on-every-page-in-ssrs-doesnt-work-o.html
2) Split reports in pages where value is taken from group by column. Basically this is a row grouper.
Provide the pagename and page split details
a) Click on Column which need to group report into pages.
b) Click on properties
c) Update Page break settings and provide pagename based on the requirement.
