SAP Knowledge Base Article - Public

1702608 - Wildcard character not working for Oracle database in Crystal Reports.

Symptom

Table name LIKE functionality not working for Oracle database in Crystal Reports.

Environment

  • Crystal Reports 2008.
  • Oracle 10.2.0.3.0.

Reproducing the Issue

  1. Launch Crystal Reports Designer.
  2. Create a blank report.
  3. Go to Database > Database Expert.
  4. Go to Create New Connection.
  5. Select Oracle server.
  6. Under Oracle server connection add the Service, User ID, Password and click on Finish.
  7. Right click on the table and click on Options.
  8. Under Database options, select Tables under Data Explorer.
  9. In Table name LIKE, type the initial alphabet of the available table name in the database (for example A%).
  10. Click on OK.
  11. Right click on the tables and click on Refresh.

Still all table names are displayed. Table names starting only with ‘A’ are not displayed.

Resolution

Install Crystal Reports 2008 Service Pack 5 (latest service pack).

Keywords

Crystal Reports, Oracle, wildcard characters. , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1