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?