In this blog, we are going to guide you through the following steps required for the successful configuration of Power ...Learn more
How to Solve RDL Sandboxing Problems that Arise When Opening SSRS Reports for D365 Finance and Supply Chain Management 10.0.13 Platform Update
Tuesday, October 27, 2020
Reading time: 2 minutes
When upgrading your UAT environment to Dynamics 365 Finance and Supply Chain Management version 10.0.13 platform update 36, you may encounter several problems with SSRS reports. Companial’s Dynamics 365 Finance and Supply Chain Management team has received feedback that Dynamics Partners are already facing some issues in relation to RDL Sandboxing.
We would like to share our experience of overcoming these issues as well as insights to help make your upgrade to the newest version of Dynamics 365 Finance and Supply Chain Management faster and less troublesome.
An error that some of our Dynamics Partners encountered while opening the project invoice report
This issue occurred because RDL sandboxing was made mandatory on the TIER 2 environments’ reporting services in the new version of Dynamics 365 Finance and Supply Chain Management. RDL sandboxing lets you restrict the usage of specific types of resources.
You can enable this feature to achieve the following objectives:
When RDL Sandboxing is enabled, the following features are disabled:
Since the Dynamics 365 Finance and Supply Chain Management platform update 36 (KB4571218), developers can enable RDL sandboxing in their development environments. You can enable and see the RDL sandboxing rules that are specified for the environment in the Dynamics 365 Finance and Supply Chain Management ‘Addins’ section.
Manual testing vs automated testing
Each update that you install has an effect on the system, and each update will have some changes. That’s why it is important to test all of the modifications, integrations, ISVs that you have, as well as all the main business processes your customer is running, to be sure that they work the same way. This will also allow the customer to feel confident about installing this update into their production environment without any functionalities being changed.
It may be necessary to adjust your local RDL sandboxing configuration to the tier 2 environment’s configuration. The configuration file is located in this directory:
C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\ReportServer\RSReportServer.config
When you have enabled RDL sandboxing in your development environment, you will be better equipped to investigate reporting issues related to this feature seeing as you will have a similar setup as that in the Tier 2 environment. The next step is to rebuild the visual studio project consisting of the SSRS reports that are causing problems and then deploy the reports. After doing that you will receive a list of detailed errors that specifies what is causing the problem. In our case, we had a global function specified on a report which is no longer supported when the RDL sandboxing is enabled. Luckily, this wasn’t a big problem for us, and we have found another approach to achieve the same result.
- How to Solve RDL Sandboxing Problems that Arise When Opening SSRS Reports for D365 F&SCM 10.0.13 Platform Update - 18/01/2023
- Advanced WHS Mobile Device Development: [Part 4] – How to Display Sales Order Line Details - 05/12/2022
- Advanced WHS Mobile Device Development: [Part 3] – The Sales Line-List Functionality - 30/11/2022