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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Running MS CRM report with Admin previlage

(1) ShareShare
ReportReport
Posted on by 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
    on at

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

    Mansoor

  • Varun Singh Profile Picture
    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
    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
    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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
JS-09031509-0 Profile Picture

JS-09031509-0 3

#2
AS-17030037-0 Profile Picture

AS-17030037-0 2

#2
Mark Eckert Profile Picture

Mark Eckert 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans