Symptom
- Date type field is converted to String type
- Wrong data type is presented in the report
Reproducing the Issue
- Crystal Reports 2008 SP1
- Microsoft SQL Server 2008 SP1
Cause
At the time of writing, Microsoft SQL Server 2008 SP1 is not supported with Crystal Reports 2008 SP1.
Resolution
Microsoft SQL Server 2008 Release Candidate 0 (RC0) is supported with Crystal Reports 2008 SP1. Downgrade it to SQL 2008 RC0 so that it properly works with Crystal Reports 2008 SP1.
Keywords
support, SQL2008 , KBA , BI-RA , Reporting, analysis, and dashboards , Problem
Product
Crystal Reports 2008 V1