Error applying filter at tablix level? (Cannot compare data of types System.Decimal and system.double)

• kelster101757

  SSC-Addicted

  Points: 436

  More actions

  January 23, 2013 at 8:56 am

  #287935

  When I apply a filter on a tablix i receive the error (the report runs fine without the filter):

  "an error occurred during the local report processing.

  The processing of FilterExpression for the tableix 'Tablix1' cannot be performed. Cannot compare data of types System.Decimal and system.double. Please data type returned by the filter expression"

  We're running SQL server 2008 and the field with the filter applied is decimal precision 18 and numeric scale 2. The operator is "<" and a value of 0. Any ideas how to resolve the problem?

• Scott Murray-240410

  SSCarpal Tunnel

  Points: 4649

  More actions

  January 24, 2013 at 3:49 am

  #1580452

  Take a look at the filter data type.