I have the following expression in a report in Visual Studio Reporting for the Filter expression of a Group:
=Fields!field1.Value < CInt(2007)
The reason for the CInt() is that the field "field1" is of type Int64 and the Expression sees "2007" as a String value. So I use CInt() to convert the value "2007" into a Integer so the types match. However, when running the report, I receive the error
"An error occurred during local report processing.
An error has occurred during report processing.
The processing of FilterExpression for the table ‘table1’ cannot be performed. Cannot compare data of types System.Int64 and System.String. Please check the data type returned by the FilterExpression."
I am very frustrated by this error. I converted the String type "2007" to an Integer value, yet it is still seeing "2007" as a String value