Skip to Content
0
Former Member
Jul 01, 2008 at 11:21 AM

Parameter with Dynamic prompt - bug encountered

95 Views

I am using CRD XI release 2 (SP2) against an Oracle 10 release 2 database

I have a report fully working with a static parameter

1. But I have an issue when trying to introduce a parameter with dynamic prompts

I have a data source (PointofSale retrieving data from a database view)

I am trying to have the newPointOfSale parameter to prompt the user for values taken out of the PointOfSale source.

I set up the parameter as indicated by the Crystal RD210 Guide.

But when I run the report I am prompted for Server Name(greyed out)/user name/password(something I have never had to do for this report until introducing the dynamic parameter)

In doubt I enter these of the database user I am using as a source for this report

I get a strange error message telling me there is a problem with another datasource on the report.

'Prompting failed with the following error message: 'List of Values failure: fail to get values. [Cause of erro: The table 'DLEX_REPORT.DLEX_REPORT_RETRIEVE.AIRLEGSUMMARY_SUM' could noyt be found. UNKNOWN.RPT]'.

Error source: prompt.ddl Error code 0x8004380D

There seem to be bug with parameters and dynamic list of values in Crystal as other people seem to encounter similar issue

Is there a fix or a workaround?

2. Also I believe this forum allows to escalate bugs with SAP/business objects. Does anyone know how to do this? As this is very obviously a bug....

Thanks

Philippe