Hi,
I have a .bat file that I use to update various systems (non Jet). I would like to add code to the .bat file to update a Jet report. The Jet report doesn't have any "options" or named ranges as these are not required for this particular Jet report.
What is the code to run Jet from a .Bat file? I have the following...
start "C:\Program Files (x86)\JetReports\AutoPilot.exe" /M "Update" /I "C:\A1test\touch.xlsx" /O "C:\A1test\Output\touch.xlsx"
This gives an error... Invalid switch - "/m".
Do the other /M commands cause the same issue? For example, if you used "VALUES" instead of "Update"?
Another thought is how the file is saved. I know the scheduling used to be very finicky and required the report to be saved in Report mode in order to work. You could try saving the report in Design mode, test. If that doesn't work, try saving in Report mode and test.
Thanks for the reply Bob. The problem was it didn't need "Start" in the .bat file.
This is the code that works...
"C:\Program Files (x86)\JetReports\AutoPilot.exe" /M "Update" /I "C:\A1test\touch.xlsx" /O "C:\A1test\Output\touch.xlsx"
Great catch. I was so focused on the Jet part of it, I didn't even notice the "start'