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.