Hi, I have a SSRS report (SSRS 2005) that runs fine and I can export it to PDF with no issues but when I export it to Excel it doesn't export everything and I'm missing a lot of data. I know that there are some limitations in excel but is there anything that I can do in my report to make the export look correct? Thank You.

SSRS 2005 can export only 65536 records only. If the report has complex design SSRS will not export properly to Excel format. If the requirement is to export to Excel and PDF I would suggest to create two RDL files one for pdf with desired design and another RDL file with same data set, with just header row and detail rows for the excel format of the report.

Hi There Can you please explain in more details what kind of problem you are facing while export to excel. Then someone might be able to help you out. is your report is too big? Did you already try table dataelementoutput property to output? It normally relates to CSV export problem but you can try. Please give some more details Many thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful

Hi Masoud.Sharifi, As it is known, there are limitations when we export reports to Excel format due to the BIFF's format capabilities. For example, some of the common limitations are as follows: The maximum number of rows in a worksheet is limited to 65,536.The maximum column width is limited to 255 characters or 1726.5 points.The Excel rendering extension only supports the background image of the report body. The background images for report items are ignored.Rectangles in report footers are not exported to Excel.If cells are merged, word-wrap does not work correctly. For the details information about Excel rendering extension limitations, please see: Exporting to Microsoft Excel If the issue persists after you follow some of the suggestions in the above article, please elaborate the issue for further analysis. If possible, please post a screenshot of the issue. Regards, Mike Yin TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

Thank you all for your responses. To give you a little more details, I'm using Rectangles to seperate out my pages and I use a mixture of charts and tables. The first 3 or 4 pages seem to export fine but then after that I see empty rectangles in the exported excel file and then after a few empty rectangle I see a rectangle with content and then again empty rectangles! So, I don't think it's the length of the content because after page 4 I'm at around line 110. Is it the rectangles that some don't translate well into excel? Masoud

Hi Masoud, Thanks for your posting. According to your feedback, the issue might be caused by the rectangles or the tables/charts in the rectangles. To narrow down the root cause, I suggest that you remove the rectangles and check the result. If there are still blank areas displaying in the replace where the empty rectangles had been, the issue may be caused by the tables in the rectangles. Otherwise, the issue may be caused by the rectangle controls. Then, please check whether you have enabled the Insert after rectangle or Insert before rectangle Page Break option for some rectangles. If so, I suggest that you clear the rectangle page break and check the issue again. Additionally, you can also try to use List control instead of Rectangle and check the result. If the issue persists, could you post a design structure of the report so that we can reproduce the issue and help you out. Regards, Mike Yin TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.