Share
Report
7,316Hi,
Can someone please help me with my questions? We recently upgraded to Dynamics 365 Online and are now building SSRS reports based on fetchxml. Earlier we used sql based.
1. Can we display NULL as a value in the parameter?
In our earlier reports, we showed ALL, NULL & rest of the values in a filter. Now in fetchxml, I see that I can either have multi select or just 'Allow Null' but not both together. How do I account for 'NULL' as a value in the parameter?
2. I used 'Or' operator in a filter in one of my reports just so I can get null value records along with all the data. Like this:
<filter type="or">
<condition attribute="new_incidenttype" operator="in" value="@IncidentType />
<condition attribute="new_incidenttype" operator="null" />
</filter>
but this is causing problems when user selects only one value from the dropdown. It brings the selected value records along with null value records! How do I let the report know to ignore 'OR' operator when only one value is selected from the dropdown?
Please provide some guidance. Thanks for any help.
*This post is locked for comments
All responses (
Answers (
