Add a Data Source

Starting in Respond 5.3, the data source cannot be edited. If a data source needs to be changed, it must be removed and a new data source must be added.

TIP: Starting in 23.3, the data source is automatically populated based on the site information.

  1. Open the Report Designer.
  1. Click the Data tab and click Add.

  1. Enter the Name of the data source.
  1. Select the Provider.
  1. Enter the Server and select the Database.
  1. Select Use Integrated Security if desired.
  1. Enter the Username and Password.
  1. Click Test Connection to validate the data source.
  1. Click Add.

After the data source is connected, a data set needs to be added as well.