My Data was created by retrieving ODBC data - using PowerPivot for Excel 2010, and has Birthdate defined as a Data Type = "Date". This was uploaded to SharePoint, and a New Dataset was created to point at it.
I'm using Microsoft SQL Server 2008 R2 Report Builder 3.0. I tried to filter this data on Birthdate, but when I go into the Filter, and specify the field that was defined as DataType = "Date" in PowerPivot - Report Builder changes the type to "Text",
and gray's out the field so that I can't change it to "Date".
If I create an Expression as Cdate(Birthdate.Value), it lets me change the Data Type to "Date", and works appropriately, but we don't want to have to do this with every date field.
Why doesn't Report Builder see this field as a Date ?
View Complete Post