SAP Knowledge Base Article - Public

1214636 - Why is the Add Command option 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 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

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 BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016