sql server reporting services: Error when applying a filter to a table -- sql server reporting services

Error when applying a filter to a table

The Whistler
8/15/2004 9:34:00 AM

sql server reporting services:

Table Properties, Filter Tab.
Added a filter.
Expression: =Fields!LastActionDate.Value
Operator: =
Value: "7/1/2004"

Receive following when previewing report:

"An error has occured during report processing. The processing of
filter expression for the table 'table1' cannot be performed. The
comparision failed. Please check the data type returned by the data
expression."

I tried Expression: =CDate(Fields!LastActionDate.Value)
I tried removing quotes from Date value.
No Luck.

Can someone help?
Thank you!

Re: Error when applying a filter to a table

Ravi Mumulla (Microsoft)
8/15/2004 10:32:52 AM

You'll also need to cast the filter Value: =CDate("7/1/2004")

--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.
[quoted text, click to view]