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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics