Repeat Headers in SSRS on each page and appear on scroll of the Page

This gave me hard time today.Finally figured it out.


To make the row headers to appear in every page and appear on scroll of the page


1) Click the grouping pane of the tablix
2) Click Advanced Mode
3) Set the Following Properties

1. FixedData -- True
2. KeepWithGroup -- After
3. RepeatOnNewPage --True

4)Set FixedColumnHeaders and FixedRowHeaders to false for the tablix

Passing Table Valued Parameters to SQL Server Stored Procedures

Passing Table Valued Parameters to SQL Server Stored Procedures

Can also be used to pass arrays to SQL Server
1) Improves performance
2) Easy to Handle
3) Get Rids of  Changing Comma Separated values to table in SQL.

1) Works only with SQL Server 2008 and above

http://msdn.microsoft.com/en-us/library/bb675163.aspx
http://www.dotnetspeaks.com/DisplayArticle.aspx?ID=47