Conditional filter in SSRS Dataset issue
Hello, I have a report using multiples parameters, allowing multi values. I'm getting all data from my sql query even those there are null in those fields. I need to include this as well in my report
I have a filter dataset like as fields!Name.Value in Parameters!ListNames.Value but doesn't include in the report those records with fields!Name.Value = Null. I'm reading that is possible to use OR
condition in a filter expresion but it doesn't work for me..
I trying to add a Filter expression
Fields!NAME.Value = Parameters!Installer.Value or Fields!NAME.Value is nothing
Fields!NAME.Value = Parameters!Installer.Value orELse Fields!NAME.Value = " "
But always I got the error "Failed to evaluate the filterValues of the Dataset ...... "
I'm very appreciate if someone can help me!!!
Thanks.....
Eliana
May 16th, 2012 7:39pm
Hi There
Can you please advise me whether your Parameters!Installer.Value is a multivalued Parameter
Are your trying to put filter on your dataset or on your Tablix then I might be able to help you
Many thanks
Syed Qazafi Anjum
Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful
Free Windows Admin Tool Kit Click here and download it now
May 16th, 2012 7:55pm
Hi There
Can you please advise me whether your Parameters!Installer.Value is a multivalued Parameter
Are your trying to put filter on your dataset or on your Tablix then I might be able to help you
Many thanks
Syed Qazafi Anjum
Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful
May 16th, 2012 7:58pm