web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Running MS CRM report ...
Microsoft Dynamics CRM (Archived)

Running MS CRM report with Admin previlage

(1) ShareShare
ReportReport
Posted on by Varun Singh 943

Hi All,

I need to run report  in MS CRM 2015 (On-Premise) with CRM admin credential and assign this report to a user who have very less previlage security role in the CRM system so that the user can see those records also in report which the user don't owned or shared with him. 

Please let me know how can I run a report with Admin credentials so that it can fetch all records in CRM reports and even normal user will able to see all records in CRM report when he run the report. 

 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    You have to give read privilege to the assigned user for the specified report data.

    Mansoor

  • Varun Singh Profile Picture
    Varun Singh 943 on at

    If I give read previlage then user will able to see others record also in views, which we don't want.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    In that case; you can think about deploying SSRS report to asp.net site and place some button in CRM main form / entity form to display report.

    Mansoor

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    If you are working with CRM On-Premise

    • Create Report using SSRS.
    • and in SSRS report -> got to Security and Provide Connection string and select "Run report always with Specified Credentials" (Sentence might differ) check box.
    • Enter User name and Password of admin.

    Using this any one can access and see data from report.

    Hope this answers...

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans