Contact

Help Center Configure Connection Settings

Configure Connection Settings

Configuring connections

When a report is added, all available connection settings from the report will be added to the [Connections] register.
If your report requires login credentials, you can enter them there.
You can also override the connections settings if needed.

Recommendation:
Crystal Reports is not required on the computer but it is highly recommended:
You can easily determine if ODBC driver or ODBC settings are missing which are needed for the report.

Microsoft SQL Server - example:

  • Windows Authentication mode:
    Connection Settings
  • (No user or password is required and Integrated Security must be enabled.)
  • SQL Server and Windows Authentication mode:
    Connection Settings Step2
  • (It requires user and password and Integrated Security must be disabled.)

For ODBC connections please use 32-Bit:

Odbc Settings

Example: Access via ODBC:

Odbc Settings Step2

Example: Microsoft SQL Server via ODBC:

Odbc Settings Step3