Microsoft Dynamics CRM (Archived)

Export button in report

(0) Share

Report

Posted on by Community Member

Hello,

My CRM 2013 users have no the "export" button in the differents reports. So they can't export in PDF or others format.

I've Administrator rights, and for me, i can see the "export" button and can export the same report.

I don't know where I can configure this feature.

Thank your for your help.

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

skhan 120 on at

Like (0)

Report

RE: Export button in report

@Karthik

Could you please tell me what modifications to ReportServer.config file you have done in order to allow users of CRM to get the export button without giving them the "export to excel" right in the CRM (I work on CRM 2011).

Was this reply helpful? Yes No
Jlavos 345 on at

Like (0)

Report

RE: Export button in report

Hi Karthik, can you tell how this was done?

and as per Adam Vero's point, was this working when reports where being called from inside CRM?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Export button in report

@Karthik - are you viewing the report inside CRM, or directly from the report server?

It has always been my experience that removing the Export to Excel privilege prevents users exporting in any format (including Excel or PDF, for example) from reports viewed inside CRM.

This is not always a good thing - it would be great to separate Excel from PDF, perhaps. Of course, once you let someone export data at all, the format becomes irrelevant - if they are determined enough to want to steal your data they will find a way to convert it or copy/paste etc.

Was this reply helpful? Yes No
Vincent TANGUY 5 on at

Like (0)

Report

RE: Export button in report

@Karthik

Could you please tell me what modifications to ReportServer.config file you have done in order to allow users of CRM to get the export button without giving them the "export to excel" right in the CRM (I work on CRM 2011).

Was this reply helpful? Yes No
Suggested answer

Karth on at

Like (1)

Report

RE: Export button in report

@Ben and Guido - That was an interesting solution! I thought 'Export to Excel' was limited to the CRM App. The Export feature on SSRS Reports is controlled by the SSRS App and could be controlled through the ReportServer.config. In fact, I revoked the 'Export to Excel' permission in CRM and tried to export data to an XL/PDF from the report and I was able to do it successfully.

Any further information on how 'Export to Excel' CRM permission is linked to SSRS?

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

RE: Export button in report

Thank you. It's now ok.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Export button in report

Thank you Guido.

I will try this with my user.

Jer

Was this reply helpful? Yes No
Verified answer

Hosk on at

Like (0)

Report

RE: Export button in report

I think you need to give the Export to Excel security priviledge to those users

[View:http://social.msdn.microsoft.com/Forums/getfile/226064:550:0]

you can see the answer in this forum post

http://social.microsoft.com/Forums/en-US/6bb422ea-188c-4346-8c15-5d6eeafb464e/crm-2011-custom-reports-enable-export-report-data-button?forum=crmdevelopment

Was this reply helpful? Yes No
Suggested answer

Guido Preite 54,084 Moderator on at

Like (0)

Report

RE: Export button in report

Hi,
you need to set the privilege "Export to Excel" inside the security role of that users. It's under Business Management:

Was this reply helpful? Yes No