I am attampting to add a Filter to a Group. The following applies to the Grouping and Sorting Properties,dialog box, Filter tab.
My expectation is that a Filter would return a Boolean, but Reporting Services reports otherwise. For ANY and ALL filters entered -- including selecting the defaults -- the following error meesage is returned:
"The processing of FilterExpression the table 'table1' cannot be performed. Cannot compare datatypes of System.Boolean and System.String. Please check the datatype returned by the FilterExpression."
Again, selecting default values from each column in the FilterExpress returns this error as well as any other entry. The message indicates that the FilterExpression is not returning True or False but instead a string of some sort. I do not see how I control the datatype for a FilterExpression. My expectation is that it would always be boolean.
This seems like it would be a simple task, but I just am missing it.
Start Free Trial
