Filtering charts

  • Hi All,

    I am having an issue with filtering on the series group in a chart in SSRS. (Dundas Product)

    I keeping getting the same error no matter what I Try.

    "An error has occured at report processing. The processing of the filtered expression for chart 'chart1' cannot be performed. Comparison Failed. Please check data type returned by filter expression."

    Can anyone help me with this. And are there anymore known issue with charts in SSRS.

    Thanks in Advanced,

    Kerrie

  • Hi All,

    I fot an answer to my question, and I figured that I would share the wealth.

    1. I stop trying to filter on series group and did it on the overall chart properties.

    2. The chart control seems to take in account character places so...

    3.Exppression            Operator     Value

    trim(field!name.value)      >           0

    4. Apparently you have to "trim" the field to get the comparison to work.

    Who Knew!!

    But I would like to thank everyone for there time,

    Kerrie

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

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