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
- Select the Add SQL Data Source button.
- In the Data Source Wizard dialog that appears, select the data source you wish to use.
- Expand the Tables option and select the tables you wish to include in the query.
Configure any Master-Detail Relationships required for the report.
For more information on Master-Detail Relationships, see Key Concepts.
- Click Finish.