DTM Query Reporter Standard

DTM Query Reporter Standard is a Windows application that enables you to generate reports based on database queries. It supports Microsoft SQL Server, Oracle, MySQL, Interbase/Firebird, IBM DB2 and PostgreSQL databases, along with multiple connection profiles and report file types.

The interface of this program is user-friendly. You can get started by putting together your first connection profile using the server name, login, password, and database. Profiles can be updated, removed from the list or exported to file to later import them, even on another computer running DTM Query Reporter Standard.

Once returned to the main app window, you can write an SQL script or load it from file, specify the saving location for the output file, and customize report settings when it comes to the style, title, paragraph size, header, footer, summary between title and header, table of contents after the title, markers, and other properties.

Connections to desktop data can be made using files in TXT, CSV, Access, dBase, FoxBase, FoxPro, Excel, Paradox, FoxPro or SQLite database format. It's also possible to connect to an existing and configured DSN file as well as to establish a connection using an OLD DB provider. Reports can be generated if you have Java Runtime Environment installed on your computer. Log details can be studied if any errors are encountered while trying to make the database connection or to create the report.

We haven't come across any compatibility issues with Windows 10 in our tests. DTM Query Reporter Standard worked smoothly and had minimal impact on computer performance. If you're interested in additional features, such as unlimited markers and column properties per project as well as command-line parameters and unattended mode, you can check out DTM Query Reporter Professional.