Database

View All Threads First Prev Next

SSRS 2005 berba6-Dec-12 6:32 berba 6-Dec-12 6:32  Hi, I've developed a report in SSRS 2005. My query is returning more that 65,000 rows and I'm getting an error when exporting the report to excel. Any idea how to solve this? The report can be exported successfully in PDF Cheers Berba Re: SSRS 2005 David Mujica6-Dec-12 7:59 David Mujica 6-Dec-12 7:59  This is a limit of Excel. I beleive Excel 2010 allows for more than 65,000. I think you only solution would be to break the results into multiple Excel documents. Remember to vote. Re: SSRS 2005 Corporal Agarn6-Dec-12 9:30 Corporal Agarn 6-Dec-12 9:30  Microsoft does not know that Excel can now hold more rows, even when you tell it to use the newer format. Re: SSRS 2005 Mycroft Holmes6-Dec-12 16:57 Mycroft Holmes 6-Dec-12 16:57  65k rows is NOT a report, it is a data dump. You are using the wrong tool for the job, you should be exporting the data as csv either from the database or your client application NOT a reporting tool! Never underestimate the power of human stupidity RAH Re: SSRS 2005 berba6-Dec-12 18:06 berba 6-Dec-12 18:06  The report is loading fine on the asp.net webpage via the report viewer control. It's just when exporting to excel the customer is getting an error. In PDF it is fine Re: SSRS 2005 Mycroft Holmes6-Dec-12 21:43 Mycroft Holmes 6-Dec-12 21:43  berba wrote: It's just when exporting to excel the customer is getting an error Which means it is the WRONG tool for the job. The tool has a limitation, as pointed out by David and djj. Never underestimate the power of human stupidity RAH

Last Visit: 31-Dec-99 18:00     Last Update: 4-May-24 10:51 Refresh 1

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.