SAP Knowledge Base Article - Public

1203908 - Crystal report using an Oracle database does not show list of values in prompts


In Crystal Reports XI, when attempting to access the list of values (LOV) from a report based on a universe using an Oracle database as the data provider, the LOVs are not listed in the prompts. The LOVs are blank.

The following workflow is used:

  1. Open Crystal Report Designer.
  2. Select a universe using an Oracle database as the data source.
  3. Create a report.
  4. Click several objects in the query panel.
  5. Drag a field to the condition pane to apply a prompt.
  6. Click the LOVs for the objects. 

When the LOV tab is clicked, no LOVs are listed.


This behavior occurs because Oracle provides strong security when users try to access data. Oracle authenticates users before accessing the data.


To resolve the behavior

  1. Open sqlnet.ora in a text editor such as Notepad.
    The file is located at <installation directory>:\Oracle\ora92\network\admin\.
  2. Locate the following parameter:


  3. Change this to the following:


  4. Save and close the file.

The LOVs are now visible in the report.


Crystal Report Universe Oracle database not show LOV prompt, 7217097 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem


SAP Crystal Reports XI ; SAP Crystal Reports XI R2