Custom code that is allowed for use in Microsoft Dynamics CRM Online FetchXML Reports

Article ID: 2600639 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

You may receive an error when you try to upload a custom FetchXML report into a Microsoft Dynamics CRM Online organization: 

Error Uploading Report
An error occurred while trying to add the report to Microsoft Dynamics CRM. 

Try this action again. If the problem Continues, check the Microsoft Dynamics CRM Community for solutions or contact your organization's Microsoft Dynamics CRM Administrator. Finally you can contact Microsoft Support. 
 

Back to the top | Give Feedback

CAUSE

Microsoft Dynamics CRM Online uses RDL Sandboxing that prevents reports from uploading or running if they contain code that uses disallowed methods. 

RDL Sandboxing

Reports in Microsoft Dynamics CRM Online run in sandbox mode, and to do this, RDL sandboxing is enabled in Microsoft SQL Server Reporting Services. Therefore, certain features might not be available in Microsoft Dynamics CRM Online. For example, custom code in your report definition will not work. For more information, see Enabling and Disabling RDL Sandboxing
(http://go.microsoft.com/fwlink/?LinkId=202795)
.

When RDL Sandboxing is enabled, the following features are disabled:
  • Custom code in the <Code> element of a report definition
  • RDL backward compatibility mode for SQL Server 2005 Reporting Services custom report items
  • Named parameters in expressions such as DateFormat or NameSpace


Back to the top | Give Feedback

RESOLUTION

When RDL Sandboxing is enabled, only certain classes and methods can be used in a custom FetchXML report. The following is a list of the classes that are allowed, and beneath each class are the available methods for use in Microsoft Dynamics CRM Online reports:

  1. Microsoft.VisualBasic.Interaction (For more information, see: Interaction
    (http://msdn.microsoft.com/en-us/library/microsoft.visualbasic.interaction.aspx)
    )
    • IIF
    • Partition
    • ToString

  2. Microsoft.VisualBasic.Information (For more information, see: Information
    (http://msdn.microsoft.com/en-us/library/microsoft.visualbasic.information.aspx)
    )
    • IsArray
    • IsDate
    • IsNothing
    • IsNumeric
    • IsReference
    • QBColor
    • RGB
    • ToString
    • TypeName
    • VarType
  3. Microsoft.VisualBasic.Strings (For more information, see: Strings
    (http://msdn.microsoft.com/en-us/library/microsoft.visualbasic.strings.aspx)
    )
    • Asc
    • AscW
    • Chr
    • ChrW
    • Format
    • FormatCurrency
    • FormatDateTime
    • FormatNumber
    • FormatPercent
    • InStr
    • InStrRev
    • Join
    • Lcase
    • Left
    • Len
    • LTrim
    • Mid
    • Replace
    • Right
    • RTrim
    • Space
    • Split
    • StrComp
    • StrReverse
    • ToString
    • Trim
    • UCase
  4. Microsoft.VisualBasic.DateInterval  (For more information, see: DateInterval
    (http://msdn.microsoft.com/en-us/library/microsoft.visualbasic.DateInterval.aspx)
    )
    • Year
    • Quarter
    • Month
    • Day
    • WeekOfYear
    • WeekDay
    • Hour
    • Minute
    • Second
  5. Microsoft.VisualBasic.DateAndTime (For more information, see: DateAndTime
    (http://msdn.microsoft.com/en-us/library/microsoft.visualbasic.Dateandtime.aspx)
    )
    • DateAdd
    • DateDiff
    • DateValue
    • Day
    • Hour
    • Minute
    • Month
    • MonthName
    • Second
    • DatePart
    • DateSerial
    • TimeSerial
    • TimeValue
    • ToString
    • Weekday
    • WeekdayName
    • Year
  6. Microsoft.VisualBasic.Financial (For more information, see: Financial
    (http://msdn.microsoft.com/en-us/library/microsoft.visualbasic.Financial.aspx)
    )
    • DDB
    • FV
    • IPmt
    • NPer
    • Pmt
    • PPmt
    • PV
    • Rate
    • SLN
    • SYD
    • ToString
  7. Microsoft.VisualBasic.Conversion (For more information, see: Conversion
    (http://msdn.microsoft.com/en-us/library/microsoft.visualbasic.Conversion.aspx)
    )
    • CTypeDynamic
    • Hex
    • Oct
    • Str
    • ToString
    • Val
  8. System.DbNull (For more information, see: DBNull
    (http://msdn.microsoft.com/en-us/library/system.dbnull.aspx)
    )
    • GetObjectData
    • ToString
  9. System.Globalization.CultureInfo (For more information, see: CultureInfo
    (http://msdn.microsoft.com/en-us/library/system.globalization.cultureinfo.aspx)
    )
    • ClearCachedData
    • Clone
    • CreateSpecificCulture
    • GetConsoleFallbackUICulture
    • GetCultureInfo
    • GetCultureInfoByLeftLanguageTag
    • GetCultures
    • GetFormat
    • ReadOnly
    • ToString
  10. System.Math (For more information, see: Math
    (http://msdn.microsoft.com/en-us/library/system.math.aspx)
    )
    • Abs
    • Atan
    • Cos
    • Exp
    • Floor
    • Log
    • Log10
    • Max
    • Min
    • Round
    • Sign
    • Sin
    • Sqrt
    • Tan
  11. System.String (For more information, see: String
    (http://msdn.microsoft.com/en-us/library/system.string.aspx)
    )
    • Clone
    • CompareOrdinal
    • Concat
    • Contains
    • Copy
    • CopyTo
    • EndsWith
    • Format
    • GetEnumerator
    • IndexOf
    • IndexOfAny
    • Insert
    • Intern
    • IsInterned
    • IsNormalized
    • IsNullOrEmpty
    • IsNullOrWhiteSpace
    • Join
    • LastIndexOf
    • LastIndexOfAny
    • Normalize
    • PadLeft
    • PadRight
    • Split
    • StartsWith
    • Substring
    • ToCharArray
    • ToLower
    • ToLowerInvariant
    • ToString
    • ToUpper
    • ToUpperInvariant
    • Trim
    • TrimEnd
    • TrimStart
  12. System.Text.RegularExpressions.Match (For more information, see: Match
    (http://msdn.microsoft.com/en-us/library/system.text.regularexpressions.Match.aspx)
    )
    • ToString
  13. System.Text.RegularExpressions.Regex (For more information, see: Regex
    (http://msdn.microsoft.com/en-us/library/system.text.regularexpressions.regex.aspx)
    )
    • Match
    • Replace
    • Split
    • ToString

Back to the top | Give Feedback
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use
(http://go.microsoft.com/fwlink/?LinkId=151500)
for other considerations.
Back to the top | Give Feedback

Properties

Article ID: 2600639 - Last Review: June 15, 2012 - Revision: 4.0
APPLIES TO
  • Microsoft Dynamics CRM Online Professional Edition
  • Microsoft Dynamics CRM Online Professional Plus
Keywords: 
kbmbsmigrate kbsurveynew KB2600639
Back to the top | Give Feedback

Give Feedback

 
Back to the topBack to the top