Symptom
-Crystal Reports 2008
-BOBJ Enterprise 3.1
-SAP BW
When using a SAP BW query as a data source for Crystal Reports/Enterprise and it contains a date type parameter that is entered by the user an error is generated.
Cause
SAP BW queries store date values as the data type DATS, which is a string field. When the query is run inside of SAP it knows to treat it as a date field and thus returns correct data. However, when date parameters are passed to Crystal from a SAP BW query it shows up as a string since that it its actual data type.
Resolution
1) Create date parameters inside of Crystal Report with the date type selected and use those in the record selection to filter on date
2) Use a dynamic picklist to select a date, not allowing users to enter custom values
Keywords
KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem