Crystal Reports with SAP BW
I have been following the your discussion in regards to the topic. We have the following scenario:
1. Created Crystal report(2008) using BW query with variable in Dev (using the SAP toolbar)
2. Saved it to BW
3. Published it to BOE (using the BW publisher and the /crystal/rptadmin transaction)
4. Transported the query and the report to Prod
5. Published the report to BOE Prod. Unfortunately, the parameter pick list still points to Dev pick list which does not have all the values.
But when we created a new report against the query in Prod and published it, it populated all the pick list values as expected.
Plan B: We opened the report and manually changed the connection to Prod, transported it again to prod and refreshed the report and now it does not have any picklist values??
The assumption was when we transported the report to Prod, it would have flipped the connection to Prod and brought in the updated pick list values.
We have been stuck on this issue for a while. Can you please help us how to proceed.
I would greatly appreciate your reply and suggestion. Thank you!