The real issue is that your filter Value is considered a string constant
"0".
When using filters that compare against integers, you have to make sure to
use an expression like =0
When using filters that compare against floats, you have to make sure to use
an expression like =0.0
Also, you may need to convert the filter expression part into the correct
data type using VB conversion functions. E.g. CDbl(...), CInt(...); check
MSDN:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vagrptypeconversion.asp
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
[quoted text, click to view] "Kerrie S via SQLMonster.com" <forum@SQLMonster.com> wrote in message
news:536DE03C51320@SQLMonster.com...
> 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
>
>
> Kerrie S wrote:
>>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
>
>
> --
> Message posted via SQLMonster.com
>
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200508/1
