When a field is formatted as date in a custom data source, as:

CAST( [fieldname]As DATE)

, after importing this data source and creating a report from it, the field is displaying time in addition to the date and cannot be formatted in Report Designer; the "Define format" button is disabled when selecting the field in Report Designer. How can we enable formatting for the field?


Create a new view using the following statement which drops the time portion:

dbo.F_DropTime(CAST(e.CreatedOn As DATE))

Import the new SQL view and create a new data provider using the new view.