SAP Knowledge Base Article - Public

1498756 - SAP BW parameter entry issue

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

Product

Crystal Reports 2008 V1