CR Parameters Issue

[Former Member]

I have a crystal report built on top of a BEx query. Now since this BEx query is shared by multiple Crystal reports, I cannot have all my parameters defined at the BEx query level and hence I am trying to define other optional parameters at Crystal report level. However, while defining the Parameter's list of values option, if I click on 'Append all values from the database', I get the below error:

Database Connector Error:

Failed to retrieve data from the database.

Error in File UNKNOWN.RPT: Database Connector Error(rptcontroller.dll)

Can someone explain me the detailed steps involved if I need to define an optional prompt at CR level based on a BEx query?

Thanks

SR

[former_member11696]

Post your questions to the SAP Integration Kit forum

[Former Member]

Hi SR,

The step by step process of creating a optional prompt is as follows :

--Create new parameter and name it.

--Chose whether it is Dynamic or Static, try to select the table field.

--Go in Value Options and select u2018trueu2019 for Optional Prompt.

--Save the parameter.

When I look at the error it is more into database connectivity, it is unable to connect to your BEx query and retrieve the values.

To narrow down the issue, instead of u2018Append values from Database Fieldu2019 try to give few values under values. (Default values) and save the parameter. If you are able to save with default values then there could be some problem with your connectivity.

Thanks,

Sastry

[Former Member]

Yes, I am able to save default values under the parameter definition and the prompt values pop-up correctly when I run the report.

But I still get the database connectivity error when I either try 'Append all values from the database' or use Dynamic method to populate 'List of Values'.

How do I debug this issue? Please help.

Thanks

SR

[Former Member]

In both scenarios, it is trying to connect to your database field. Is there anything that you can create a new connectivity and check this by creating a new report.

Also if you can try to test the issue in any other system where you have the same configuration, this will help us to debug the issue.

Thanks,

Sastry

[Former Member]

I tried creating a new connection and a new report, it still doesn't work. Currently I am trying to access my BEx query using MDX drivers. Please help.