SAP Knowledge Base Article - Public

1498756 - SAP BW parameter entry issue


-Crystal Reports 2008
-BOBJ Enterprise 3.1

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.


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.


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


KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem


Crystal Reports 2008 V1