Active Table Editor Reports

One of the major benefits of Active Table Editor is its ability to create rich, customisable reports directly from your database data.

Report Designer

Report Measurements

The units of measurement used in the report are displayed on the horizontal and vertical rulers in the Report Designer. By default, measurements are usually shown in centimetres, but the measurement units can be changed if required.

The rulers help you position report elements precisely and design the report according to its intended printed layout.

Each report object can be positioned using:

• X — the horizontal position of the object.
• Y — the vertical position of the object.

Using X and Y coordinates makes it possible to precisely position data, titles, and other elements within the report.

Report Tool Bar

1. Saves Report to the Repository
2. Report Connection

Creating New Report

Click plus to create new report

Report Properties

Fill in all necessary details and click ok

Report Wizard

Data Source

Query Builder

Fields Selector

Groups

Layout

Style

Report in Report Designer

Resetting Report Designer

It possible to hide some report designer objects accidentally. This can be easily addressed by removing settings from the registry

1. Close application
2. Delete the following registry key : HKCU\SOFTWARE\Fast Reports\

Print Preview

Reports for Non Admin Users

Only administrators can design Reports. End users can only view and print them

Attaching reports to the forms

One of the benefits on using Active Table Editor is the ability to link reports to forms.

The reports can be be linked via Menu items

Or via the form

List of linked Reports

This screen can be used to edit existing linked reports or to add new ones. (Admins only)

Once the report is created it is possible to link to the form by using variables.

To see the list of variables within designer, Click Report => Variables

List of variables

Whe report is linked to a form or grid it gets list of variables from it. Those variables are populated with fields values when report is generated

Link parameter to the report

Previewing linked report

Video Tutorial