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 ?

Hi Wikinson, Currently, have to use the CDate function as workaround, and then submit a feedback at https://connect.microsoft.com/SQLServer/Feedback and hope microsoft resolve it in the next release of serivce pack. thanks, Jerry

Hello all. I have the same issue but in Report Builder 2 but the CDate workaround doesn't stick - Report Builder keeps insisting on changing the data type back to "text". Anyone got any other solutions? Many thanks in advance.

Bump. . .

Bump. . .

Anybody there?