Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Financial Reports no l...
Finance forum
Unanswered

Financial Reports no longer viewable by users - no security changes

Posted on by 29

Users with the Review Financial Performance duty (thus View Financial Reports privilege) have been able to view financial reports until this week. 10 of the reports still open fine. 22 reports will not open. We made no security changes. The error they receive is:

This report can't be displayed

  • Make sure that you have access to one of the following items:
    • A unit in the reporting tree
    • The report in the report library

Work with your administrator to determine if you have access.

 

Troubleshooting:

1. Added Everyone group to the Reporting Tree on the summary row and all unit rows in the MR Report Designer (note: The Reporting tree isn't the issue as some of the reports that fail use the same tree as some of the reports that still work. Also, we leave the tree wide open on security - we don't restrict it to anyone)

2. Recreated a report from scratch - it has the same issue

3. Added higher privileges (Maintain / Generate Reports)

- This allows users to open generated reports

- Interestingly, if a users opens a generated report once and then we remove the elevated privileges, they can continue to open that generated report but cannot open other generated reports of the same report definition

- We can't leave elevated privileges on permanently as a fix

4. Rebuilt the datamart - using "Reset Datamart" in the report designer

5. Restarted the Financial Reporting service in LCS 

The page error is 403 forbidden:

pastedimage1665083986887v1.png

Regarding the second part of the error, "The report in the report library" - my understanding is that report level security is no longer relevant in D365 and we have no control over that.

We have a premier ticket open with Microsoft support but that hasn't been fruitful for several days.

Anyone else see anything similar recently? Did Microsoft push Windows Server or SQL Server updates to the dynamics production servers last weekend?

Categories:
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,914 Super User on at
    RE: Financial Reports no longer viewable by users - no security changes

    Hi Leemor,

    Unfortunately, I'm not able to help. When you mention that nothing got changed from your end, then it would be something to be investigated by Microsoft. You have already created a ticket. If the response is slow, you can send a reminder to the person in charge of the ticket.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,914 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,549 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans