Hi...Suggest me the ways that i can generate a report for huge data i.e. it shouldfetch more than 900k records.I tried generating reports using ssrs 2008but i am getting out of memory exception and if iam implementing through subscription it gives "thread was being aborted".Version info:Microsoft SQL Server Management Studio10.0.1600.22 ((SQL_PreRelease).080709-1414 )

Please install at least cumulative update #1 to solve this specific problem. Better yet, install SP1 with the latest cumulative update (i.e. SP1 CU#3). Download links are available here.HTH,RobertRobert Bruckner http://blogs.msdn.com/robertbruckner This posting is provided "AS IS" with no warranties, and confers no rights.

Hi Robert, I am having the same issue thread being aborted for my subscription which is trying to render 130MB size report. I am using sql 2008 R2. The problem occurs only if i run more than one subscrition for the same report. thanksUsman