SAP Knowledge Base Article - Public

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


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


  • Crystal Reports 2008.
  • Oracle

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.


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


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


Crystal Reports 2008 V0 ; Crystal Reports 2008 V1