Link to home
Start Free TrialLog in
Avatar of fesnyng
fesnyng

asked on

Filters in Reporting Services -- what data type is returned?

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.

ASKER CERTIFIED SOLUTION
Avatar of ptjcb
ptjcb
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of fesnyng
fesnyng

ASKER

Thank you.  At least I now know what is being returned by the Filter tab (FiterExpression).

So, why is Reporting Services attempting to read the FilterExpression as a Boolean?  This is a little strange for default behavior.
It may be, and this is a guess, using both sides of the string expression to return true or false. That's fairly standard in development.

I know that in creating ad hoc reports you use a drop down box that is populated with distinct values.



Avatar of fesnyng

ASKER

It is all drop down boxes on the Filter tab.  I selected ALL values from the drop downs.  No typos possible.  I have not attempted to write an expression. Throws the error shown based on default items selected from the drop downs.  I have only taken what Reporting Services gives me.  Pretty frustrating.
Avatar of fesnyng

ASKER

Well... not entirely what I needed BUT you did answer my question exactly how I framed it.  And, I had been to that link without putting it together how that fit to my question.  So, I am closer to where I need to be.  Thank you very much for helping.