Control the paging functionality manually

hi all,

In my Reports, i want to handle the paging functionality manually, c i have a query called "Select * from employees" it has a total number of records of 100, in which it is displaying some 50 rows in one page and the next in the other page, wat my requirement is , i want to display 10 rows per page and the remaining in the next pages. this is killing me in the look and feel, so pls help me in this, wating for a reply as soon as possible, how to do it ?

Thanks in advance

Venkat.

check this:http://aspnet.4guysfromrolla.com/articles/031506-1.aspx

HTH|||

Hi,

Checked the link,its not related with reporting services, i like to do custom paging in the report (.rdl) in sql server 2000 reporting services

waiting for a reply

thanks in advance

Venkat.

|||Just setting the height of the report page will do it .