SSRS fetchxml allow null values only when All selected

(0) Share

Report

Posted on by meenoo

7,316

Hi,

I have a report with fetchxml query like this:

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!

I have the same question (0)

All responses (1)

Answers (0)

meenoo 7,316 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No