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?