i want to display a dataset of 10k record or more, but bounding time is too long so i want to get first 30 record from sql server , when click the next page button ,then get get the second 30 record and display it with reporting services can i do it with ssrs 2008? thanks

Hey, Please check the following link: http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/65bcac50-a6be-4872-b28d-3e3974e11d35 This should hopefully help you.Please mark correct answers :)

Hey, Please check the following link: http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/65bcac50-a6be-4872-b28d-3e3974e11d35 This should hopefully help you.Please mark correct answers :)

Thanks for your reply but I want to do something like this: select top 30 * from ( select top Globals!PageNumber*30 * from table1 order by id) A order by id desc there are 10 million records in table1, select * from table1 ,and Render then in Reporting services, the wating time is too long. so I only want to get 30 records from the database,when clicked next page, get other 30 records from the database. any solution to do this?

Any help?