Product Home
DTM Query Reporter Online Documentation
General information
Product profile
Connect
Report options
Profiles
Product settings
Query customization
Command Line
Additional information
Database utilities
Licence agreement
Demo and Full versions
Product ordering
Install
Uninstall
Upgrade
Support
Glossary

Command line options

DTM Query Reporter supports following command line switches:

-r - if project file was configured, run the report automatically at the program startup.

-q - quit application after project execution.

-c - console mode.

-s - source SQL file with query. Examples: -sd:\sql\query.sql or -s"d:\My sql scripts\query.sql"

-o - output file. Examples: -od:\reports\customers.doc or -o"d:\My documents\John\results.html"

-v - file with values. Example: -vd:\vals.txt

Also you can use project name as a command line parameter.

Note: -r and -q switches are not required in the console mode. The program applies them automatically.

Example:
qr.exe -r -q -o"d:\My documents\John\results.html" d:\SQL\ShippersReport.qrp

The console mode is a mode when the program doesn't open any dialogs and doesn't need any actions from the user. A project file for the console mode must be prepared and tested beforehand. This mode enables you to integrate the product with the Windows task schedule system as well as to execute projects prepared beforehand according to the schedule.

For example, in order to execute a predefined project file at 12:00, use the following command line:
at 12:00 "qr.exe -c d:\SQL\ShippersReport.qrp"