Add SQL Data Source

Geocortex Reporting can save multiple data sources to a named user account. The Add SQL Data Source button launches a wizard that allows you to add one of these saved data sources to a report, configure a query to one or more tables in the data source, and configure a master-detail relationship if required.

Run the Data Source Wizard

  1. Select the Add SQL Data Source button.
  2. In the Data Source Wizard dialog that appears, select the data source you wish to use.
  3. Expand the Tables option and select the tables you wish to include in the query.
  4. Configure any Master-Detail Relationships required for the report.

    For more information on Master-Detail Relationships, see Key Concepts.

  5. Click Finish.