Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

RPTS$ The report cannot be displayed (NOT ONPREM)

(0) ShareShare
ReportReport
Posted on by 437

CRM Online

admin can create and run personal and organization reports.

User cannot run reports "The report cannot be displayed" error is given

User cannot run the report wizard.

pastedimage1626780562728v2.png

Is there a way to make it so users using online CRM can create and run reports? 

Most everything online is for onprem.

  • urklnme Profile Picture
    urklnme 437 on at
    RPTS$ The report cannot be displayed (NOT ONPREM)
    UPDATE 1/26/24
     
    I removed all of the assigned security roles and removed the user from all teams.
     
    I added one security role:  System Customizer.  
     
    User can now run reports.
     
    Why this is the case I do not yet know.  Hopefully more to come.
  • urklnme Profile Picture
    urklnme 437 on at
    RPTS$ The report cannot be displayed (NOT ONPREM)
    it has been a couple of years and still no resolution to this problem.
     
    The user in question is a super user basically.  many privileges but not quite a System Admin.
     
    We pay a lot of money for this stuff and it just doesn't work or nobody knows how to make it work.  very disappointing.
     
     
     
     
  • urklnme Profile Picture
    urklnme 437 on at
    RE: RPTS$ The report cannot be displayed (NOT ONPREM)

    Anyone?  some knowledge of run report process?  

    I also added the read privilege to the Entity and Field in the appropriate security role.

  • urklnme Profile Picture
    urklnme 437 on at
    RE: RPTS$ The report cannot be displayed (NOT ONPREM)

    Thank you Wahaj.  Yes, the report is very simple.  case records older that 30 days based on reported date.  My user has privileges to do most everything one can do in the application.  She is the manager of the app.  She has CRUD privileges on most tables.  

    My user cannot run reports (cannot display error)or create reports (privilege error) using the wizard.

    Other things:  

    All reports are Viewable by: organization.

    Related record types is: Cases

    I set the owner of the reports to my user

    I set miscellaneous privileges "Publish Reports" and "Add Reporting Services Reports"

    Users only have read-only privileges.  All other privileges are inherited from the team to which they belong.  I have run into other issues where this does not work, that the privileges must be on the user itself.  I am checking that.

    I always expect too much, like a process like this should be documented somewhere.   Do "this" to allow users to create and run reports.

    These types errors have been occurring in powerapps for over 10 years.  

  • Suggested answer
    Wahaj Rashid Profile Picture
    Wahaj Rashid 11,319 on at
    RE: RPTS$ The report cannot be displayed (NOT ONPREM)

    Hi,

    Thank you for your query.

    Make sure users have permissions on the records on which reports are executed.

    Verify their roles and privileges in the records (used in the reports).

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,419 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,492 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans