Automate Export Using Query Reporter and Windows Task Scheduler

[marty]

Hello, I am new to using Task Scheduler and Query Reporter..am using Win7 and QR version 3.3.1.350

I had read a thread in the forum where it was stated QR could be used with Windows Task Scheduler to run/automate the export of sql code saved in QR as a .rep file.

I was able to get as far as figuring out how to create a Windows Task that opens QR and the .rep file I am interested in exporting. However, I am not sure how to then get it to automatically export.

Any help about how to do this is greatly appreciated!

 

[Marco Kalter]

You can use Command-Line parameters to control things. For example:

queryreporter.exe userid="scott/tiger@chicago" exec=C:\qr\report01.rep csv=C:\qr\report01.csv quit

This starts query reporter, connects as scott/tiger@chicago, executes the C:\qr\report01.rep report, saves the results in C:\qr\report01.csv and quits.

See the User's Guide for more information and examples.

 

[marty]

ok, thanks..