Hi,
In this post I would like to introduce you to the new feature set provided by MSSQL server 2012 (syntax) for paged result sets using the “OFFSET FETCH” clause
http://technet.microsoft.com/en-us/library/gg699618(v=sql.110).aspx
Now we got the SQL in place to provide the flexibility, so how we go about leverage it. For the same, I have sketched out a very user friendly interface with all the features of a paged report along with the features for the user to operate upon the rows:
The above report provided the functionalities of sorting, paging, user selections and operations upon the same with the help of dynamic sql constructed by the help of variables.
Give it a try with the code base provided in the download and I hope it provide you the infrastructure required to achieve similar for your feature rich reports.
Downloads: