I need the ability to have my SSRS 2008 R2 reports render to Excel 2007 in order to get past the 65,536 row limitation. Is this possible?

Hi, This is the know problem of SSRS, No you cannot render to Office 2007. Please read below links:- http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/364ab37c-7902-4f04-9ea8-c2f1b693931b http://msdn.microsoft.com/en-us/library/ms156418.aspx http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/d2b6c9d6-17c4-46aa-8b57-e1f37ff7413d Thanks Kumar KG, MCTS

I got the "=Int((RowNumber("TablixData")-1)/65000)" on a parent group to generate multiple worksheets. Thanks! Nathan

Hello Nathan, Please complete the thread as Marked if your question as been Answered. Thanks KumarKG, MCTS

The new SQL Server Reporting Services "Denali" will include the Excel 2007-2010 renderer http://msdn.microsoft.com/en-us/library/ms170438(v=SQL.110).aspx#ExcelRenderer This posting is provided "AS IS" with no warranties, and confers no rights

Wow thats great news Jaime. Thank You for your information.KG, MCTS