Visual Linking

Ad hoc reporting has a very powerful yet intuitive graphical interface to easily create and modify data connections over several database tables. The interface consists of the database tree and the table linking view.

Database Tree

The database tree offers every table, stored procedure or otherwise accessible data component of your selected data source. To select a table to take your data from, simply drag it from the database tree into the table linking view. You can also double click a table to add it.

A representation of the selected table will appear on the right side, showing all available columns.

Table Linking View

After adding multiple tables or stored procedures to this view, you can easily join them:

  • Click the source column of the first table
  • Click the destination column of the table you want to join with

Now a connection between those two columns appears. It has a box in the middle where you can set the JOIN Type and the Link Type.