CRM Sub Report failing whit Null GUID parametr RRS feed

  • Question

  • I have a SSRS report for CRM. It contains a sub reports.  The below error occurs when the sub report parameter value (which is of a type GUID) is null.

    An error occurred during local report processing

    An error occurred during rendering of the report.

    An error occurred during rendering of the report.

    Value cannot be null.

    Parameter Name: value

    Using the below expressions I tried, with no success, passing nothing, empty strings, and a blank GUID (00000000-0000-0000-0000-000000000000).

    • =Iif(IsNothing(Fields!guidField.Value), nothing, Fields!guidField.Value)
    • =Iif(IsNothing(Fields!guidField.Value), "", Fields!guidField.Value)
    • =Iif(IsNothing(Fields!guidField.Value), "00000000-0000-0000-0000-000000000000", Fields!guidField.Value)

    Extra information;

    • The sub report parameter has allow nulls and allow blanks checked.
    • The sub report can be generated from VS 2012 report designer with the null checkbox checked.
    • The report uses fetch xml and has pre filtering enabled.
    Tuesday, May 19, 2015 6:39 AM