Data type Changed

[back2tek]

Hi All:
A report is designed using CR9.2 . Datasource is ODBC connection to an MS access view/query. The MS Access view is collecting data from 2 linked tables in a sybase database.

The issue is related to a date field in sybase table that the Crystal report is showing as datetime. I am using this field to link to a subreport. Any idea why this is happening? how can I change the datetime field to date field from Access or from CR.

Thanks in advance

 

[satinsilhouette]

Try making a formula that converts the field into date

date({sybasedatefield}) and see if that works.

Thanks so much!
satinsilhouette

 

[synapsevampire]

MS Access doesn't have a date type, only datetime.

As Satin suggests, create a date from it within Crystal to use to link to the subreport.

Keep in mind that subreports are generally the slow, try returning all of the data required for the report within an Access Query.

-k