Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error applying filter at tablix level? (Cannot compare data of types System.Decimal and system.double) Expand / Collapse
Author
Message
Posted Wednesday, January 23, 2013 8:56 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 30, 2013 12:53 AM
Points: 10, Visits: 24
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?
Post #1410645
Posted Thursday, January 24, 2013 3:49 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, August 29, 2014 4:19 AM
Points: 243, Visits: 2,686
Take a look at the filter data type.
Post #1411032
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse