vendredi 9 mars 2012 18:51BOTTOMLINE: Does anyone know of any fixes or workarounds to enable Access Services to export report data to Excel or Word as detailed below?
PLEASE NOTE: I am talking about Access Services running under SharePoint; not client-side Access applications.
When a report is rendered on the web, there is an Actions button (at bottom left hand corner) which provides the options to print the report or export the report data to .pdf, Excel or Word (see first image). Printing works and exporting to .pdf also works just fine. However when you try to export to Excel you receive the message shown in the second image and when you click ‘Yes’ Excel opens up but there is no data. When you try to export to Word, the application (Word) opens up but there is nothing in the file (i.e., a blank Word document). In addition, export works fine when the user los in as administrator.
Based on a variety of web searches regarding this issue, it would appear that this was a known, unsolved problem way back at the end of 2010 (for example: http://accesshosting.zendesk.com/entries/266484-exporting-report-data-to-ms-excel-or-ms-word)
Does anyone know how to get the exportation of report data to Excel and Word to work?
Toutes les réponses
lundi 12 mars 2012 10:14
mardi 13 mars 2012 20:00
Thank you Wayne Fan.
mardi 13 mars 2012 21:21Ask your administrator if Excel services have been configured on the server.
mercredi 14 mars 2012 14:34Yes, Excel services is configured on the server.
mardi 20 mars 2012 15:35Did anyone find a solution for this?
mardi 20 mars 2012 21:57
Can you share which browser you're currently attempting the export with? Can you test with granting the end user "Modify" rights on %WINDIR%\Temp to see if the export is then successful to Word and/or Excel?
mardi 20 mars 2012 22:16
I'm using i.e.8.
I granted the end user "modify" on the temp directory, but the export still didn't work.
It only works when the user logs in using the admin username and pwd.
mercredi 21 mars 2012 21:13
Thanks for trying that for me. I haven't found any other indication of what the problem may be, nor a valid workaround for this issue, so what I would recommend is that you open a paid support case so that the team that supports Access Services can identify what the problem is in your specific scenario. I'm sorry that I wasn't able to identify a solution for you.
jeudi 26 avril 2012 19:43
I found this post recently, as I am having the same issue. Looks to be an issue with access to SQL:
Not sure what a good solution is though....
Erich O'Donnell | SharePoint Administrator