D365 F&O Management Reporter Troubleshoot issues opening Report Designer

 

Issue 1 - Report Designer doesn't start when you select "New" or "Edit"

Resolution

Check the Event Viewer:   If the Issue related to Change Tracking :

Run the below script:

ALTER DATABASE AxDB SET CHANGE_TRACKING = ON (CHANGE_RETENTION = 2 DAYS, AUTO_CLEANUP = ON)

IF related to User Permission:

To solve this issue, follow these steps:

• In Internet Explorer, select Settings > Internet Options > Security > Trusted Sites > Sites. In the Add this website to zone field, enter \*\.dynamics.com, and then select Add.

• In Internet Explorer, select Settings > Internet Options > Security > Trusted Sites. In the area labeled Security level for this zone, change the option to Medium-Low.

• Disable the pop-up blocker in your browser.

• Install Microsoft .NET Framework 4.7.2 or higher to workstations.

• If you're using the Chrome browser, you must install the ClickOnce extension to download the Report Designer client. If you're running Chrome in incognito mode, make sure the ClickOnce extension is enabled for incognito mode. For more information about the Chrome ClickOnce extension, see System requirements for cloud deployments.

• If you're using Microsoft Edge with the Chrome browser, you don't need to install the ClickOnce extension for Microsoft Edge Chromium. However, you must enable the ClickOnce option to download the Report Designer client. If you're running incognito mode, make sure the ClickOnce extension is enabled for incognito mode.

1. Open a new browser in Microsoft Edge.
2. Enter edge://flags and select Enter.
3. Search for the ClickOnce Support option or use this direct link: edge://flags/#edge-click-once.
4. Set the drop-down menu option to Enabled.
5. Select Restart Browser.

Management Reporter Connection Issue

 

1. Issue: Unable to connect to Management Reporter and received below mentioned errors:

2. Taken UAT DB Write Access to run the script shared by Microsoft:

Script #2: Script should run on the AxDB:

UPDATE FINANCIALREPORTINGSETTINGS SET SETTINGVALUE = 0 WHERE SETTINGKEY = 'DisableMaps';
IF @@ROWCOUNT=0 INSERT INTO FINANCIALREPORTINGSETTINGS(SETTINGVALUE, SETTINGKEY) VALUES (0, 'DisableMaps')

Step#2:Re-start MR services after running the above script

3. Run the script in UAT AxDB

 

4. Executed the script:

 

5. Restart the MR Service from LCS
6. Click on Restart Service
    

 

7. Select the Financial Reporting Service

8. Again, try to open the Financial Reports: