When you create a new empty report without report wizard for the first time (see Welcome Page), you should open the Database Wizard to add a connection. Note that you can later edit this connection in the Database Wizard.
See the Data Source Manager Guide for more information on how to set up a connection, configure it, import existing data source configurations, as well as export configurations. Note the settings enable you to be able to save the database password in the configuration, as well as many other things.
You may want to have more than one database connection to choose tables from. Tables from various connections can be joined and used as if they were all from the same connection. In order to add a connection to your report, click the "Add Connection" button in the toolbar above the tree.
This will open up the "Connection Manager" dialog where you can select the data source for the new connection. Note that once you have more than one connection in your report, the connections become color-coded so you can distinguish which connection the tables are from.
Removing a connection is only possible if the connection is not being used by any tables or fields in your report. To remove a connection, select it and click on the "Remove Connection" button above the tree.
In order to refresh the database connection and the used database objects, simply select the connection in the Database Browser and click on the Refresh button at the top of the database browser. This will reload all data for the tree in the database browser as well as for your chosen database object(s).
If the database structure was changed, then it can happen that used database objects or columns are no longer exists in the database. In this case the suitable objects are crossed out and the dialog "Replace missing columns" appears.
The left column contains the used columns that no longer exist in the database. In the rigth column you can select the column with that the missing column will be replaced. Missing columns can only be replaced with columns of the same type.
If you close the dialog without replacing the column, then you should delete the column or change the location of the database object. If missing columns are not replaced, then it is not possible to execute the report because formula exceptions or missing column exceptions will occur.
Once you have created your report template, you can use the Database Wizard to see the actual SQL statement(s) used by i-net Clear Reports to fetch the data for your report. To do this, simply click on the "Show SQL" button at the bottom of the dialog. This will show you the SQL statement(s) in a window, enabling you to copy and paste the statement(s) for your own use. Note that this window will be empty if you are not using any fields at all in your report, since this means you are not selecting any records.