Hi All,
I've been trying to make use of the jet report scheduler and batch file but can't get them to function as I was shown during Jet Reports training. I'm hoping someone can see the steps I'm taking listed below and tell me if I'm doing something wrong, or if my scheduler and Batch Files are the issue.
Scheduler:
I am able to schedule a report to run and it will run at the time and output location I specify perfectly. However, when I revise any of the options on the Advanced Tab insuring that the Filter Value is correct and the Update field lists YES, the report does not run with the updated values. The report is run with all the option on the input file. Also, I am hoping that there is some way to have the output report save with a name other than the original file, but I'm not sure if that is possible with the scheduler.
Batch File:
I have had nothing but frustration with the Batch file, but I'm also sure that I must be missing a key step somewhere. I have attached a batch file example to show you how I have formatted the batch file. In the file I have a /p command to udpate the name range "FundFilter" on the Input report. I was told that I still use the scheduler to run the batch file, and that will in turn cause the reports listed in the batch file with the various parameters I have defined to also run. But the only thing that happens when I run a batch file from the scheduler is that the batch file copy pops out. But the reports targeted in the batch file do not run.
If anyone has any suggestions as to what I must be doing wrong, or whether there is something else that is not working properly I would really appreciate you sharing those thoughts.
Thanks in advance the the assistance.
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi DMDG,
Whenever I run into any issues with the Scheduler, I always start by logging the errors. This will create a .txt file that will let you know what steps have been taken and if anything went wrong. You can do this from the Scheduler on the "Output" tab. You can also do this for your batch file by adding a new column (before the /p section) for "/l C:\NameOfLogFile.txt". Of course you can put the log file where ever you like. This will hopefully give you some insight as to what might be going wrong with your scheduled reports.
I did take a peek at your batch file. The only thing that stands out to me is that you are using mapped drives. Try using the full UNC path instead to see if that works.
Please sign in to leave a comment.