SAP Knowledge Base Article - Public

1214636 - Why the Add Command option is not visible in Crystal Reports?

Symptom

  • Add Command option is not visible.
  • In Crystal Reports, in the Database Expert, the Add Command option is not available.
  • The Add Command option is found in the connection folder for active Database Files or ODBC data sources.

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020

Reproducing the Issue

  1. In Crystal Reports, create a native connection to a Sybase data source
  2. Notice there is no "Add Command" option under the native Sybase connection

Cause

  • The "Add Command" is not an option when connecting natively to the following data source:
    • Native connection to the SQL-type databases: IBM DB2, Sybase, Informix,...
    • Native connection to PC-type databases such as Paradox and FoxPro (the exceptions are Microsoft Access and Microsoft Excel)

Resolution

  • Connect to your data source using an ODBC connection.
  • The Add Command option will always appear when connecting to your database through ODBC.

Keywords

NO ADD COMMAND OBJECTS BUTTON NATIVE SMI NATIVE DRIVER NOT THERE DATABASE EXPERT Crystal Reports Where is the Add Command option? Native database connections Command object , c2011374 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020