Hi all,
I ran a report using the command line below (CMD.exe), didn't get any error, but also didn't get any result back either, not even a log file.
Can someone help. Thanks
C:\>"Program Files (x86)\JetReports\autopilot.exe" /M "update" /I "c:\TestDisc.xlsx" /O "C:\OutputXXX.xlsx" L/ "C:\logfile.txt" e/ "Test@Test.com"
/p "Discretionary_Date" ""8/24/2012..12/31/2012"" "State_Group" ""Canada""
Date
Votes
17 comments
-
Jet Reports Historic Posts Hi Richard,
I think your quotes are a little off. First I'm assuming you meant to type "/e" and not "e/". I think the /P part at the end should be more like this:
/p "Discretionary_Date" "8/24/2012..12/31/2012" "State_Group" "Canada"
Maybe the double double quotes is throwing off the parsing of the command line. The other possibility is that AutoPilot is having a hard time writing directly to C:\. In Windows Vista and Windows 7, the root of the C drive is a protected area and you may need to try writing into a folder instead. Do either of those things help?
Regards,
Hughes -
Jet Reports Historic Posts Hi fhilton,
After making the changes according to your suggestion i was able to run the command, but after running the comamnd i got an error in the error log. I was trying to find out what is causing the error(0x8004060) but no luck so far. Here is the error message in the log file, wondering if you can help.
2012-08-24 07.11.08 The message could not be sent.
2012-08-24 07.11.08 Could not submit the message - error 0x8004060
Thanks -
Jet Reports Historic Posts Hi Richard,
If you use /E like this, Jet is going to try and use Microsoft Outlook to send the email. It looks like Outlook had some problem sending the email, so I would encourage you to try using SMTP instead. You have to set up the SMTP server settings in the Jet Application Settings and use the /S flag in your AutoPilot command. Does this help?
Regards,
Hughes -
Jet Reports Historic Posts Hi fhilton,
Thank you for your esponse, i will try to do that. -
Jet Reports Historic Posts Hi fhilton,
I have a question. I was able to send out report via email using Jet scheduler, which means microsoft outlook is working and i am wondering should it also works for autopilot.exe in a batch file or you would need to use SMTP?
Thank you, -
Jet Reports Historic Posts Hi fhilton,
Please disregard the last question, i was able to use /E to send mail.
Thank you -
Jet Reports Historic Posts Hi Richard,
I'm glad you figured out the problem. Just to clarify on that question about the Scheduler vs. AutoPilot. The Jet Scheduler is just a front end for AutoPilot. Anything you schedule with the Scheduler gets scheduled as an AutoPilot command line in the Windows Task Scheduler. If you open the Windows Task Scheduler, you can look at the AutoPilot command lines for the tasks you scheduled via the Jet Scheduler.
Regards,
Hughes -
Jet Reports Historic Posts Hi fhilton,
I have a question. I am using the command below run a report which will create a workbook that has two sheets in it and they both receive the same parameters, but when i execute the command only the active sheet received the parameters and not the other one, if i run the report using an option page then they both get the parameters. Is there a way to correct the problem?
Thank you,
C:\>"Program Files (x86)\JetReports\autopilot.exe" /M "Update" /I "C:\TestDisc.xlsx" /O "C:\output\report.xlsx" /L "C:\log\logfile.txt" /P "Discretionary_Date"
"1/1/2012..6/30/2012" "Start_Date" "1/1/2012" "End_Date" "6/30/2012" -
Jet Reports Historic Posts Hi Richard,
The way these parameters are set on the workbook is via an Excel named range. So you have Excel named ranges called "Discretionary_Date", "Start_Date", and "End_Date" in your report, but named ranges with those names can only exist on one place in the report. It seems like putting the named ranges on the options sheet would be the correct way to go. Then you should be referencing the cells on the options sheet on your other sheets in order to get the values. Are you saying your cell references to the options sheet aren't working?
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
I've corrected the problem by creating an option page and passing the the parms to it.
I have another question. Can you execute the autopilot command within a Visual Basic application? If yes would you have a sample of it?
Thank you, -
Jet Reports Historic Posts Hi Richard,
Yes I'm sure you could execute AutoPilot from Visual Basic. AutoPilot could fairly easily be executed with a shell command. I don't do much Visual Basic programming these days so I don't have an example of that, but if you google for executing a shell command from Visual Basic I'm sure you could figure it out.
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
I am using Shell command to execute the autopilot from a VB program, but i was just wondering if you can do it w/o using shell.
Thank you for your help… -
Jet Reports Historic Posts Richard,
If you're asking whether AutoPilot has a public API you can access from Visual Basic, the answer is, no it does not. I'm afraid the shell command is your best bet.
Regards,
Hughes -
Jet Reports Historic Posts Thank you
-
Jet Reports Historic Posts Hi,
I have a question regarding scheduling. I have been able to click on the "schedule" icon on the menu bar to schedule the report to be send out, but for some reason the schedule icon is greyed out now. Can you help?
Thanks. -
Jet Reports Historic Posts Richard,
I have no idea why your Scheduler icon would be disabled. Maybe you upgraded Jet, but didn't activate the Jet Excel add-in for the newer version? At any rate, that sounds more like a question for Jet Reports Support than the community forum. If you create a support ticket, I'm sure someone will be able to help you.
Regards,
Hughes -
Jet Reports Historic Posts Thank you
Please sign in to leave a comment.