Thanks for your reply. We have table that has 31 million records. Report service will commnunicate with database table and has to display the data.

We have storeprocedure to filter the data on datewise with timestamp . Some records has null timestamp and report is taking more thane 30 minutes to pull out the records for 1 day.

Regards,

Ram