Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Restrict ssrs report to be visible by only administrator.

(0) ShareShare
ReportReport
Posted on by 2

Hi All Experts,

I have one SSRS Report which needs to be visible to Administrator only.

I have change the Category to Administrative Report , but still it's displayed to normal users only.

any help will be appreciable .

  • a33ik Profile Picture
    84,325 Most Valuable Professional on at
    RE: Restrict ssrs report to be visible by only administrator.

    So click it - the second option.

  • EmployeeOcta Profile Picture
    2 on at
    RE: Restrict ssrs report to be visible by only administrator.

    Hi Wahaj,

    I am seeing the second option i.e. "Revert to Personal Report".

  • Suggested answer
    Wahaj Rashid Profile Picture
    11,321 on at
    RE: Restrict ssrs report to be visible by only administrator.

    Hi,

    What do you see for these options?

    pastedimage1624968294824v3.png

    pastedimage1624968286595v2.png

  • EmployeeOcta Profile Picture
    2 on at
    RE: Restrict ssrs report to be visible by only administrator.

    Myself System Adminisrator, and for Administration tab the owner is a custom user

    CRM Administrator with System Administrator as security Role.

  • Wahaj Rashid Profile Picture
    11,321 on at
    RE: Restrict ssrs report to be visible by only administrator.

    Hi,

    What role do you have?

    Can you please share a screenshot?

  • EmployeeOcta Profile Picture
    2 on at
    RE: Restrict ssrs report to be visible by only administrator.

    Hello All,

    I am trying to change it to the "Individual" but this option is not editable.

  • Suggested answer
    Charan Raju C R Profile Picture
    7 Moderator on at
    RE: Restrict ssrs report to be visible by only administrator.

    Hi EmployeeOcta,

    1. Create a new team (say, Admin Users Team)

    2. Add only the users who supposed to run the particular reports to this Admin Users Team. In future, if you need to allow any non-system admin users to run the reports, you can just add them to this team

    3. Assign a security role (you can create a one) which has minimum read access to Report entity

    4. Under Administration tab of the reports you wanted to display only to the admin users, set Viewable By to Individual and Owner to 'Admin Users Team'

    4. Security Roles expect System Administrator and the one created at step #3, should not have org level permission on report entity

    Update: I just realized that Wahaj Rashid's answer also correct. All the users with system admin role can see the report. But you need to ensure no other roles having org level read permission on Report.

  • Suggested answer
    Wahaj Rashid Profile Picture
    11,321 on at
    RE: Restrict ssrs report to be visible by only administrator.

    Hi,

    Thank you for your query.

    Try the following steps:

    - Open the report in Edit mode.

    - In the "Administration: tab, make sure the "owner" is the "Admin user".

    - Set the "Viewable By" to "Individual".

    - Save the report, now the only owner of this report could see it.

  • EmployeeOcta Profile Picture
    2 on at
    RE: Restrict ssrs report to be visible by only administrator.

    I am using CRM onpremise 8.2 version.

  • Nya Profile Picture
    29,058 on at
    RE: Restrict ssrs report to be visible by only administrator.

    Hi,

    Would you please specify which application you're using in Dynamics? 

     

    Best Regards,
    Nya

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,865 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,723 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans