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 AX (Archived) / User security with SSR...
Microsoft Dynamics AX (Archived)

User security with SSRS reports - permission error

(0) ShareShare
ReportReport
Posted on by Community Member

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

*This post is locked for comments

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

    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

  • Community Member Profile Picture
    Community Member on at

    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 on at

    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 on at

    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

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    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

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    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.

  • Community Member Profile Picture
    Community Member on at

    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

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 AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans