Has anyone seen/resolved issue with Report Builder 3.0 not exporting correctly to MS Excel format?
Posted on 2014-07-17
We have experienced an unexpected problem when exporting to Excel, either directly from Report Builder 3.0 and/or from the front end SharePoint report repository. The export creates undesirable formatting results. Somewhere in the process the report's formatting as designed in Report Builder becomes corrupted in producing the output. More specifically, random cell borders disappear, cell alignment is all over the place, cells may be inserted in odd places, and columns cannot be resized. This is a big deal to some of our customers, requiring manual manipulation to "fix" an automated output.
We removed within the .rdl file any additional white space that may have created extra pages or spaces in the report. It did not resolve the problem.
We re-wrote the report and encountered the same errors.
It appears that the only way to get a "clean" export resembling the intended format is by exporting to PDF or to MHTML. Unfortunately, neither of these formats is editable, and that's a key requirement for our customers.
We also tried to take the .pdf output and use AdobeExportPDF Online to convert the .pdf output to .xlsx, and that resulted in similar formatting errors and borders missing, although it's not as bad - I can resize the columns and cells are in the columns where they should be.
We found that if we export the Excel file from Report Builder (not Sharepoint), then open the Excel file in Google Docs, the missing borders are restored. The report displays and prints more in line with how the report looks in Report Builder. But the results are still not where we need them. And, u sing Google Docs isn’t a clean or viable "solution" as you need to upload documents to Google Docs before you can view them. This doesn’t sit well from a HIPAA / data privacy protection standpoint and few of our customers have or allow use of Google Docs.
So we're seeking any info on how the problem has been handled elsewhere and whether anybody knows of the root cause so we can address it.