SSRS 2012: Excel invalid file on ipad/safari/.... - by Cohen

Status : 


Sign in
to vote
ID 774678 Comments
Status Active Workarounds
Type Bug Repros 8
Opened 12/18/2012 12:48:53 PM
Access Restriction Public


An excel report from reporting services with Sql Server 2012 is unable to open on ipad (in safari) and or any office application availlable for ipad.

When we open and save the file in excel all the programs on ipad have no problem in opening them.

After looking at the differences in the xlsx-xml files between the file generated by reporting server and the excel file from Excel the following differences are the cause:
 - in [Content_Types].xml an override element to workbook.xml is missing
 - the contentType for xml extensions should be: application/xml

Additional Excel saves it's path's relative while SSRS uses an absolute path's. 

Why not render the files the same as Excel?
Sign in to post a comment.
Posted by Ram Valluri on 6/22/2017 at 2:39 PM
Hi Cohen,

I am having the same issue and was not able to open the .xlsx on iPhone. Can you please let me know how to transform the Xml inside of the xlsx file.

Posted by adriantheuma on 11/7/2016 at 10:07 PM
This is happening in SSRS 2014 with iOS 10. Is Microsoft going to issue a fix for this?
Posted by GoudenEi on 7/22/2016 at 7:13 AM
Also unable to open ssrs generated excels in Integration Services using the Microsoft.ACE.OLEDB.12.0 driver. "external table is not in the expected format". Workaround: resave the file with Excel :-(
Posted by CCTien on 10/22/2015 at 1:49 PM
We have been using email subscriptions with Excel attachments and we just found out that these files cannot be opened on our I-phones when we're not connected to the company network. This seems to defeat the purpose of having these email reports if we cannot view them while we're out on the field.... The Excel file does not have the connection string so it should be a static file.

Our workaround is to use PDF file, but we don't know why Excel does not work.
Posted by Bluey47 on 2/27/2014 at 8:00 PM
Still happens in SSRS 2012 SP1. iPhone/IPAD can’t open any SSRS xls or xlsx exported report. Very annoying.
Posted by ptrubs on 11/13/2013 at 1:24 PM
This is the same issue as

(so go and vote on both!)
Posted by ShashankJain on 9/25/2013 at 9:56 PM
@ Cohenl : if you solved it please give us your solution, we need it very urgent,
if any other have any solution please share with us...
Thanks in advance but it is very disruptive to us....
Posted by PGovind on 5/8/2013 at 10:15 PM
@Cohen - Could you please explain more about "transforming the Xml inside of the xlsx file"?
Posted by smithtm on 3/28/2013 at 2:15 PM
@Cohen - can you explain the process of "transforming the Xml"?
Posted by Cohen on 1/11/2013 at 9:14 AM
@Greg, we solved it by transforming the Xml inside of the xlsx file. We still have one issue with images. Overall it looks fine. If you're interested, let me know.
Posted by Greg E on 1/7/2013 at 10:51 AM
This is very disruptive to all my business users, as it did work not too long ago.
Applies to SSRS 2008 R2 also. I have been testing on 2012 to see if that would work better.