Studio

Taurec Studio offers the comprehensive set of tools for designing high-performance reports and dashboards. This section details the report construction kit, interactive analysis features, and advanced scripting capabilities for complex logic.

Construction kit

A worksheet consists of a grid. As with a construction kit, objects are placed on the grid using drag & drop. Even inexperienced users can create appealing reports in no time at all.

There are different objects for the various use cases, e.g:

• Filters
• Tables
• Trees
• Pivot
• Graphics
• Spreadsheets
• Maps

User views

Users designing worksheets are supported by wizards located on the left and right side. For example, you can create graphics by simply dragging the required table from the database tree onto the worksheet. The wizards are hidden for users who do not have rights to design reports.

Interactive

The finished reports are not a rigid construct. End users can filter, sort, total or group them as they wish. These functions are also available on mobile devices in the app.

Special functions

The Studio is also used for more advanced tasks. It can be executed time-controlled in the background, e.g. to automatically prepare data and import it into the database.

Scripting language

A scripting language is integrated for more advanced tasks. It is based on Basic or Pascal syntax and is easy to learn. It can be used, for example, to process data, send e-mails, call up operating system functions or control filter settings. The Studio can also be executed in the background on a time-controlled basis. The script that is to run is given as a parameter when the program is called. This can be used, for example, to automatically generate SQL queries, prepare the returned data records and import them into the database.

SQL interface

Relational databases are often used as a pre-system. ADO is used to access such databases. ADO can be used to access almost all common databases, such as SQL Server™, Oracle™ or Access™. Text or Excel™ files can also be integrated. Another advantage is that ODBC is a component of ADO. SQL commands can be created simply by drag & drop but can also be entered manually. The commands can also be parameterized. For example, it can be set that only the current month is loaded in the WHERE condition.

Data can also be written back to the database via the SQL interface. INSERT or UPDATE commands are generated for this purpose.