Symptom
While changing the data source location in crystal reports 2008 the values which are entered manually in static prompts disappears.
Environment
Reproducing the Issue
- Create a crystal report based on sample SQL server stored procedure.
- The stored procedure contains static parameters.
- Enter the value in static prompt manually e.g. if the static prompt is date prompt then the values entered are 1/1/2009 and 1/2/2009.
- Migrate the report to BOXI 3.1 and Crystal report 2008.
- Change the datasource location.
- In CR 2008 Service pack 0, when the data source location is changed, the static parameter values are available or static prompt retains the values entered in earlier version.
- In CR 2008 SP1, the static prompt does not retain the values.
Cause
This is known behavior and has been tracked in ADAPT01324661.
Resolution
The fix will be available in Businessobjects XI 3.1 Service Pack 3.
Keywords
ADAPT01324661. , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
Product
SAP Crystal Reports XI