Paged Report in Jedox Web

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:

CropperCapture[4]

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:

 http://amolpandey.com/home/downloads/blog22_download.zip

Posted in Uncategorized

Leave a Reply

Your email address will not be published. Required fields are marked *

*