Reconciliation allows you to do what consultation does not allow: to have in the same query several data sources coming from several databases.

When the reconciliation type is selected, the choice of the data source is grayed out, as well as the checkbox for time out and automatic disconnection.

At the time of sélection des sources de données, no table can be selected, only queries.

This is the analog for l'écran de jointures for a consultation.

Here again, the screen differs from the consultation (see field selection).

• We can't sort the records.
• The fields used in the reconciliation criteria are obligatorily displayed in the final report, so this screen only offers the additional fields.

The rest of the screen is similar.

The following screens of the consultation are absent when creating a reconciliation :

• appendix screen
• Currency decimal screen