|
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"
|