SQLServerCentral / Reporting Services / Reporting Services / Error applying filter at tablix level? (Cannot compare data of types System.Decimal and system.double) / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 03:44:43 GMT20RE: Error applying filter at tablix level? (Cannot compare data of types System.Decimal and system.double)http://www.sqlservercentral.com/Forums/Topic1410645-150-1.aspxTake a look at the filter data type.Thu, 24 Jan 2013 03:49:47 GMTScott Murray-240410Error applying filter at tablix level? (Cannot compare data of types System.Decimal and system.double)http://www.sqlservercentral.com/Forums/Topic1410645-150-1.aspxWhen 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?Wed, 23 Jan 2013 08:56:16 GMTkelster101757