1. Dynamic report templates. These files have .dtt extension.
The description means, that the files do not contain actual report data; each such file contains a template with information about how to build a specific database report: database connection details, SQL query text, visual report definitions, printing options etc. The report template is filled with database data dynamically after you click Preview.
These files can be edited and executed in Database Tour Pro. When opening a dynamic report in the program, there are two possible program behaviours:
- If the report is opened from inside the report builder, and database and data set were already opened, then the loaded report is applied to currently opened dataset (therefore, some links between visual report objects and database fields may become invalid). After saving the report, old database and data set definitions in the file will be replaced with currently opened ones.
- In all other ways of opening such files, the file database and data set are opened, and then report builder is loaded. If you wish
to edit the report template without opening the associated database, then hold SHIFT
when opening such files.
These files are intended to be executed on some regular basis on changed data. Generated report (i.e. filled with data) can be exported to a static report (see below).
2. Static reports. These files have .stt extension.
The description means, that the files are not intended to be edited; each such file contains an already generated database report (i.e. contains database data) in binary form. Unlike dynamic reports, static reports do not require database connection to be opened. When opening a static report in the program, the report preview is opened.
These files are useful, for example, when sharing your reports with users who do not have access to your database.