A report file is a file which contains Database Tour Pro / Reportizer database report definition. There are two types of report files:
1. Dynamic report templates. These files have .dtt extension.
The type name 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 behaviors:
- 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 type name means, that the files are not intended for editing; 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.
If these files are associated with the Database Tour Pro, clicking on one will start the program and load the report.
The report files can be used in the following programs: Database Tour Pro, Reportizer, Reportizer Viewer. Each report file contains information about version of report engine, which was used to create the file. You can check the report engine version using Help | About... section of these programs. In order to avoid possible incompatibility errors when opening report file in the program, please make sure the program's report engine version is equal or larger than the file's report engine version.