Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX forum / User security with SSR...
Microsoft Dynamics AX forum
Answered

User security with SSRS reports - permission error

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Good morning,

We have our security set up around user functionality.  Currently we have a Role - Customer account manager.  This role needs access to the Report Customer aging. (AR -> Reports -> status -> Customer aging)  When this is put on the customer account manager menu it appears correctly and the user can fill in the appropriate parameters but when the report runs the user gets the error :-

"Access denied to method processReport in CustAgingReportDP"

When I look at the menu it points to a menu item Output CustAgingBalance.  In the menu item properties I see that the the security is set to LinkedPermissionType SSRSReport, LinkedPermissionObject  is CustAgingReport and the LinkedPermissionObjectChild is the first report format for that report.

If I then look at that report and check the report designs they all have permissions set up in server methods pointing to the CustAgingReportDP.processReport.

Currently the only user profile I can run this report with is the System Administrator. 

Can someone please let me know which setting I've missed to enable this to work.

Many thanks

Paulina

Categories:
Reporting and BI
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: User security with SSRS reports - permission error

    Many thanks, I have re checked the priviledge and found the access was at read (I was sure I'd changed it to delete)  which was causing my second problem. All good now

    Many thanks

    Paulina

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: User security with SSRS reports - permission error

    I had the same problem, in my case the report runs correct in one company but not in other, and this solution was the only thing who fix the issue:

    You add the menuItem to the Privilege, and then create a new server method, and add the class the method and the EffectiveAcces to Invoke.

    We always use one privilege for all the reports.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: User security with SSRS reports - permission error

    Hi Paulina Mudgway,

              Have you tried this report in different user who don't have admin rights?

    If it is working with some-other user, then re import user(who not to run this report).

    Thanks

    Suresh

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: User security with SSRS reports - permission error

    Hi Suresh,

    Not quite sure what you mean by "add report correspondings to privilege".  The report itself is in the user priviledges, the access is delete on this, the access on the methods are invoke. The entry point it set as CustomerAgingBalanceGenerate.  After changing anything in the AOT I will clear cashe, run incremental CIL and in this case I also restarted the AOS.

    I think there is another area that needs to be added to the priviledges that SysAdmin can see but this user cannot.  This report it the only one that is giving us problems.

    Thanks

    Paulina

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: User security with SSRS reports - permission error

    Hi Paulina Mudgway,

    as Tatiana Garcia Ramos shown privilege, you need to add report correspondings to privilege!

    check your entry point, check access level on entry point! clear the cache and run incremental CIL. try run the report again.

    Thanks

    Suresh

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: User security with SSRS reports - permission error

    I have done this and I now get another error - which doesn't happen in the SysAdmin user.  "Cannot insert multiple records in Mapping of dates to ageing buckets (CustVendAgingPeriodScaleTmp).

    The record already exists"

    Why set up the Linkpermissions on the report if it is never used?  I have added the table named above into the permissions but this doesn't help.  Any more ideas?

    Thanks

    P.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics AX 2012 R2 User security with SSRS reports - permission error

    you can do this:

    Add the server method into the Privilege.

    This way the user will have access to the process method.

    2728.Ledger.png

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

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

Community Spotlight for September 2024

Kudos to Mohana Yadav!

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,252 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,089 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans