Hi all,
I am stuck with a problem in scheduler. I use scheduler quite often, but this time it won't run as I expect.
I am trying to get a dynamic list of projects to run a cost-report, and have made a report "Summary projectkosten.xslx" tot generate the report itself.
To run the report for all projects with recent costs only, I made a report "Nightly-built-batch.xlsx" that is triggered by the scheduler; below is the code in this file."C:\Program Files (x86)\JetReports\Autopilot.exe" /M "Update" /I "O:\FC\JetReports AutoPilot\Summary projectkosten.xlsx /O "O:\FC\JetReports AutoPilot\output\Projectkosten 18924.694 (%YEAR%%MONTH%%DAY%_%HOUR%%MINUTE%).xlsx" /E /B /U /p "projectnr" "18924.694" 18924.694
The last entry (18924.694) is the result of the function =NL("Rows";"Job";"No.";"Input Hours Total Cost";"<>0";"Global Dimension 2 Code";"JIP|MARKT") that gives me all relevant projects.
In Scheduler itself another Output path is specified as this is mandatory. This path is "\\MARIN.LOCAL\Department\FC\JetReports AutoPilot\Output\nightly-built-report.xlsx".
What happens is that when I run the scheduler, the "nightly-built-batch.xlsx" is executed, and it is then saved expanded with all projects that I wanted using the filename as in the previous line. The report "Summary projectkosten.xlsx" is NOT started.
I compared it with other scheduled reports that run without problems, and cannot find any difference.
Am I doing something wrong here, am I overlooking something? Help is greatly appreciated……
Kind regards,
Willem@Marin
Date
Votes
3 comments
-
Jet Reports Historic Posts Official comment Solved it!!!
In the scheduler-file the named range was only 1 row, where it should have been 2 rows. Beginner's mistake :oops: ….
Running like a charm now!
Willem -
Jet Reports Historic Posts Hi Willem,
My guess is that your problem is related to the O: drive. This is probably a mapped network drive. When a scheduled task is run when you are logged out of the computer, mapped network drives will not be mapped. So you must use the full server path to the input and output files the same way you are doing in the scheduled task itself (\\MARIN.LOCAL\Department instead of O:). Does this help?
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
Although several other scheduled files run with the same settings from the same path, I followed your suggestion but this did not help me.
I have now discarded the old file and made a fresh one. As I am somewhat lazy, my preferred method is copy/paste what works and then change what is needed. Now it works, but the file in the \I input field is run only once for the first project (18924.694) found by the NL(Rows) function=NL("Rows";"Job";"No.";"Input Hours Total Cost";"<>0";"Global Dimension 2 Code";"JIP|MARKT")in the last column.
This NL(Rows) function gives over 400 projects, so I would expect that the file in /I input field is run that many times."C:\Program Files (x86)\JetReports\Autopilot.exe" /M "Update" /I "O:\FC\JetReports AutoPilot\Summary_projectkosten.xlsx" /O "O:\FC\JetReports AutoPilot\output\projectkosten_18924.694.xlsx" /E "w.broos@marin.nl" /B "test" /U "test " /p "projectnr" "18924.694" 18924.694
How can I get this to work as I expect?
thanks in advance.
Please sign in to leave a comment.