filter IDs

  • Hi all,

    Can someone help me with this. I have some Ids which I want to filter from my report. I would want to filter them in the dataset using the dataset filters i.e the IDs <> 1234, 12344 etc. My report is coming up with error "The FilterValue expression for the dataset ‘DataSet1’ contains an error: [BC30205] End of statement expected". I tried to put bracket at the begining and at the end like IDs <> (1234, 12344) and I am having this error "The FilterValue expression for the dataset ‘DataSet1’ contains an error: [BC30198] ')' expected."

  • What you want is a not in, not just <>.

    This should help you on the right tracks,

    http://blog.datainspirations.com/2011/01/20/working-with-reporting-services-filters-part-4-creating-a-not-in-filter/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply