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?