Select the “Database” data source: You will see a form with the following data: Provider – select the required data source from the drop-down list Server name – specify server name Authentication – authentication method Database – database name Now, in the appeared form select the method for selecting the data: Query – possibility to […]

In the “Data Source Wizard” window, select the “Query” method and use the “Run Query Builder …” button: The following form appears:

To add a table, either drag it to the “Diagram” pane or double-click on it: Then select the required columns: Note that if at least one table has been added to the “Diagram” pane, the “Tables” pane highlights tables that have a relationship with any of the recently added tables: To join the already added […]

After you have added the tables and selected the required columns, you can change settings for each column in the “Grid” pane: The following settings are available for each column: Column – the possibility to select the required column from the combo box or add a new column. If necessary, you can customize the column […]

To filter data in the “Query Builder”, click the “Filter …” button: This will open the “Filter Editor” dialog, which allows you to build the filter criteria:

The “Query Builder” allows you to add query parameters when creating filtering criteria. To specify the parameters of the added query parameters, click the “Edit parameters …” button: In the opened form, add a new parameter (using the «Add» button) and specify its parameters: Name – parameter name; Type – parameter type; Expression – specifies […]

After you add required tables and views, you can customize the automatically generated “SQL query”:

The “Query Builder” allows you to preview data for the created “SQL query”. To do this, click the «Preview Results…» button:

In the “Data Source Wizard” window, select the “Stored Procedure” method, select the required stored procedure and click on the «Next» button: In the next window you can specify the parameter settings: Note. Use of the “Stored Procedure” is only possible for the following data sources: Microsoft SQL Server, Oracle, Teradata, Firebird, IBM DB2, MySQL, […]

After connecting to the data source and selecting the necessary data, you can edit the “Query” / “Stored procedure” or add another “Query” / “Stored procedure” to the data source. To do this, use buttons from the “Query” group in the “Data Source” tab: Add Query – adds a new query to the data source. […]