web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

RDLSandboxing enabled

(0) ShareShare
ReportReport
Posted on by 383

Hello every one ,

i face the below error when trying to print sales invoice in sandbox event it working fine in development

pastedimage1608130008623v1.png

I have the same question (0)
  • nmaenpaa Profile Picture
    101,160 Moderator on at
    1. What kind of sandbox is it?
    2. Did you customize this report?
    3. Do other reports work in this sandbox?
  • AhmedSaeed Profile Picture
    383 on at

    Hi, Nikolaos Mäenpää

    It's d365 f&o sandbox

    Yes i edit the report 

    Yes all reports working fine 

         

  • nmaenpaa Profile Picture
    101,160 Moderator on at

    What kind if changes did you make to the report? Perhaps something that's not supported, as the error message says. 

  • Verified answer
    WillWU Profile Picture
    22,361 on at

    Hi AhmedSaeed,

    This issue occurred because RDL sandboxing was made mandatory on the TIER 2 environments’ reporting services in D365FO. RDL sandboxing lets you restrict the usage of specific types of resources.

    You can enable this feature to achieve the following objectives:

     1.Regulate external resource sizes that include images, .xslt files and map data.

     2.When publishing a report, limit types and members that are used in expression text.

     3.When processing a report, limit the length of the text and the size of the return value for expressions.

    When RDL Sandboxing is enabled, the following features are disabled:

     1.Custom code in the <Code> element of a report definition.

     2.RDL backward compatibility mode for SSRS (SQL Server 2005 Reporting Services) custom report items.

     3.Named parameters in expressions.

    Refer to:

    docs.microsoft.com/.../enable-and-disable-rdl-sandboxing

  • AhmedSaeed Profile Picture
    383 on at

    i found this expression (code.AMOUNTTOWORDSARABIC(Round(Fields!InvoiceAmount.Value, 2)) in report design is it cause a problem?

  • Suggested answer
    nmaenpaa Profile Picture
    101,160 Moderator on at

    Hi,

    you can test if it causes problems. Basically you enable SSRS rdl sandboxing in your dev system to verify. The standard D365 Cheque reports convert the numbers to text in x++ so perhaps you should do that, too.

  • AhmedSaeed Profile Picture
    383 on at

    Hi Nikolaos Mäenpää ,

    i'm trying to enable  rdl sandboxing by adding the below code in rsreportserver.config file but it didn't enabled  rdl sandboxing

    <RDLSandboxing>

         <MaxExpressionLength>5000</MaxExpressionLength>

         <MaxResourceSize>5000</MaxResourceSize>

         <MaxStringResultLength>3000</MaxStringResultLength>

         <MaxArrayResultLength>250</MaxArrayResultLength>

         <Types>

           <Allow Namespace="System.Drawing" AllowNew="True">Bitmap</Allow>

           <Allow Namespace="TypeConverters.Custom" AllowNew="True">*</Allow>

         </Types>

         <Members>

           <Deny>Format</Deny>

           <Deny>StrDup</Deny>

         </Members>

       </RDLSandboxing>

  • AhmedSaeed Profile Picture
    383 on at

    Hi Will Wu,

    what you mean by (1.Custom code in the <Code> element of a report definition.)

  • WillWU Profile Picture
    22,361 on at

    Hi AhmedSaeed,

    It means the custom code in your report.

    community.dynamics.com/.../is-it-possible-to-disable-rdl-sandboxing-in-tier-2-environments

  • AhmedSaeed Profile Picture
    383 on at

    Hi Will Wu,

    i found the problem : when enable RDLSandboxing it's didn't support any expression in report design like (iif,Format,Row Number,...) but i need to use these expressions in my report so i think this feature is very bad and we can call it (a bug)

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…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 592 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 478 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 305 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans