Hi,
I have a report with fetchxml query like this:
<filter type="or">
<condition attribute="new_typeofcase" operator="in" value="@CaseType" />
<condition attribute="new_typeofcase" operator="null" />
</filter>
This is the only way I can think of to get null values as well when 'All' is selected in the filter. Please let me know if there is another approach.
But using this approach, when a particular value is selected from the filter, it retrieves the desired rows along with null value rows. So, to avoid this, I am thinking in the Tablix properties, I should probably write some expression to detect whether All is selected, so that only then bring null value rows otherwise don't! How do I achieve this?
Not sure if this is possible... but please let me know if I am thinking it right or if there is a better approach.
Thanks for any help!
Any help is appreciated.
I tried adding an expression to Tablix filter:
=IIF(Parameters!CaseType.Count>1,Fields!typeofcase.Value,Parameters!CaseType.Value)
This is working fine for false part. I am not sure how to handle 'True' part.
When only one value selected from casetype filter, I get accurate results(no nulls).
But when I select 'All' from the filter, I am getting inaccurate results. I am sure I have the 'True' part all wrong in my expression.
All I need is to figure out how to specify in the expression that, when 'all' is selected, bring everything including null value records.
Anybody please provide some guidance. Thanks.
André Arnaud de Cal...
291,969
Super User 2025 Season 1
Martin Dráb
230,842
Most Valuable Professional
nmaenpaa
101,156