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.