Share via


RDL sandboxing for Microsoft Dynamics 365 (online)

 

Applies To: Dynamics 365 (online), Dynamics CRM Online

In Microsoft Dynamics 365 (online), the reports run in the sandbox mode. This is done by enabling Report Definition Language (RDL) Sandboxing in Microsoft SQL Server Reporting Services. The RDL Sandboxing lets you detect and restrict the usage of specific types of resources. As a result, certain features in Microsoft Dynamics 365 (online) may not be available. For more information, see MSDN: Enabling and Disabling RDL Sandboxing.

The current RDL Sandboxing configuration settings in Microsoft Dynamics 365 (online) are described in the following sections in this topic.

In this topic

Limits of the array result length and string result length

Allowed types and denied members

Common denied members

Limits of the array result length and string result length

The maximum number of items allowed in an array return value for an RDL expression is increased from 250 to 102400. The maximum number of items allowed in a string return value for an RDL expression is also increased from 250 to 102400. This enables you to include images and logos with sizes up to 75 KB, which will be stored in a database with Base64 encoding.

The MaxResourceSize is set to 2000. This lets you include external images in a report up to 1500 KB in size. More information:  Add an External Image (Report Builder and SSRS)

Allowed types and denied members

The RDL Sandboxing feature enables you to create a list of approved types and a list of denied members. The list of approved types is called an allow list. The list of denied members that are not permitted in the RDL expressions is called a block list.

The following table contains a list of allowed types and denied members available in sandbox mode in Microsoft Dynamics 365 (online).

Allowed Types

Denied Members

System.Array

CreateInstance

Finalize

GetType

MemberwiseClone

Resize

System.DateTime

FromBinary

GetDateTimeFormats

GreaterThan

GreaterThanOrEqual

System.Object

GetType

MemberwiseClone

ReferenceEquals

System.DbNull

Finalize

MemberwiseClone

GetObjectData

GetTypeCode

System.Math

BigMul

DivRem

IEEERemainder

E

PI

Pow

System.String

System.TimeSpan

Hours

TicksPerDay

TicksPerHour

TicksPerMillisecond

TicksPerMinute

TicksPerSecond

Zero

TryParse

TryParseExact

System.Convert

ChangeType

IConvertible.ToBoolean

IConvertible.ToByte

IConvertible.ToChar

IConvertible.ToDateTime

IConvertible.ToDecimal

IConvertible.ToDouble

IConvertible.ToInt16

IConvertible.ToInt32

IConvertible.ToInt64

IConvertible.ToSByte

IConvertible.ToSingle

IConvertible.ToType

IConvertible.ToUInt16

IConvertible.ToUInt32

IConvertible.ToUInt64

System.StringComparer

Create

Finalize

System.TimeZone

Finalize

GetType

MemberwiseClone

System.Uri

Unescape

Parse

Escape

Finalize

System.UriBuilder

Finalize

System.Globalization.CultureInfo

ClearCachedData

System.Text.RegularExpressions.Match

Empty

NextMatch

Result

Synchronized

System.Text.RegularExpressions.Regex

CacheSize

CompileToAssembly

GetGroupNames

GetGroupNumbers

GetHashCode

Unescape

UseOptionC

UseOptionR

capnames

caps

capsize

capslist

roptions

pattern

factory

IsMatch

Matches

Iserializable.GetObjectData

InitializeReferences

RightToLeft

Options

Microsoft.VisualBasic.Constants

vbAbort

vbAbortRetryIgnore

vbApplicationModal

vbArchive

vbBinaryCompare

vbCancel

vbCritical

vbDefaultButton1

vbDefaultButton2

vbDefaultButton3

vbExclamation

vbFormFeed

vbGet

vbHidden

vbHide

vbHiragana

vbIgnore

vbInformation

vbKatakana

vbLet

vbLinguisticCasing

vbMaximizedFocus

vbMinimizedFocus

vbMinimizedNoFocus

vbMsgBoxHelp

vbMsgBoxRight

vbMsgBoxRtlReading

vbMsgBoxSetForeground

vbNo

vbNormal

vbNormalFocus

vbNormalNoFocus

vbObjectError

vbOK

vbOKCancel

vbOKOnly

vbQuestion

vbReadOnly

vbRetry

vbRetryCancel

vbSet

vbSystem

vbSystemModal

VbTypeName

vbVolume

Zero

Microsoft.VisualBasic.ControlChars

Finalize

GetType

MemberwiseClone

Microsoft.VisualBasic.Conversion

Err

ErrorToString

Fix

Microsoft.VisualBasic.DateInterval

Finalize

GetType

MemberwiseClone

Microsoft.VisualBasic.Financial

Finalize

GetType

MemberwiseClone

IRR

NPV

MIRR

Microsoft.VisualBasic.Interaction

AppActivate

Beep

CallByName

Command

CreateObject

Environ

Finalize

GetAllSettings

GetObject

GetSetting

GetType

InputBox

MemberwiseClone

MsgBox

SaveSetting

Shell

Choose

Switch

Microsoft.VisualBasic.Information

Erl

Err

IsError

IsDBNull

Lbound

Ubound

SystemTypeName

Microsoft.VisualBasic.Strings

Finalize

GetType

MemberwiseClone

Lset

Rset

Microsoft.Crm.Reporting.RdlHelper

Common denied members

The following table contains a list of denied members common in allowed types:

DateString

Duration

Equality

Equals

Erl

Filter

GetChar

GroupNameFromNumber

GroupNumberFromName

Int

MaxValue

MinValue

Negate

Timer

TimeString

ToBinary

Finalize

GetType

MemberwiseClone

See Also

Report & Analytics with Dynamics 365
Example reports

© 2016 Microsoft. All rights reserved. Copyright