I have an interesting problem. When I run the attached auto pilot, some of the output files get a #Value error message for the value fields. However, when I open up those output files and run the report (in non-auto pilot mode), those fields populate properly. I don’t understand what is causing the problem, because the programming commands in the bat file appear to be the same for the files that do and don’t work. These are the files that are generating the error message:
- "%ProgramPath%" /m %Mode% /i "%BasePath%\%InputPath%" /o "%OutputPath%\1000_AA\2009-10" /p "Dept" "1000" "proj" "*"
- "%ProgramPath%" /m %Mode% /i "%BasePath%\%InputPath%" /o "%OutputPath%\1100_Alumni Relations\2009-10" /p "Dept" "1100" "proj" "*"
- "%ProgramPath%" /m %Mode% /i "%BasePath%\%InputPath%" /o "%OutputPath%\1105_YAC\2009-10" /p "Dept" "1105" "proj" "*"
- "%ProgramPath%" /m %Mode% /i "%BasePath%\%InputPath%" /o "%OutputPath%\1850_Ridley\2009-10" /p "Dept" "1850" "proj" "*"
- "%ProgramPath%" /m %Mode% /i "%BasePath%\%InputPath%" /o "%OutputPath%\1900_Administration\2009-10" /p "Dept" "1900" "proj" "*"
- "%ProgramPath%" /m %Mode% /i "%BasePath%\%InputPath%" /o "%OutputPath%\1950_Maintenance\2009-10" /p "Dept" "1950" "proj" "*"
- "%ProgramPath%" /m %Mode% /i "%BasePath%\%InputPath%" /o "%OutputPath%\1960_Facilities\2009-10" /p "Dept" "1960" "proj" "*"
- "%ProgramPath%" /m %Mode% /i "%BasePath%\%InputPath%" /o "%OutputPath%\7000_Parents\2009-10" /p "Dept" "7000" "proj" "*"
- "%ProgramPath%" /m %Mode% /i "%BasePath%\%InputPath%" /o "%OutputPath%\FAAJ_Jefferson Trust\2009-10" /p "Dept" "AAJ100" "proj" "FAAJ*"
The rest of the output files in this bat are working fine. Any ideas as to how to fix this problem would be greately appreciated.
Thank you!
Ashley
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Van,
Thanks for your help! It turned out to be an incorrect formula in a cell in the input file that only appeared on a few reports once they were run.
Ashley -
Jet Reports Historic Posts What does the actual report formula for the cells that are returniong Value contain ?
I've seen this when I've referenced a cell that should be in text format but for whatever reason scheduler loses that ( ie you get 1 instead of 01). Especially true if cross sheet reference - easiest solution I've found is to Np("Eval", Formula) whether thats TEXT(cell1:"00") or date range or just a cell value on different sheet then reference the NP( Eval cell in formulas on the sheet thats erring
Hope that makes sense
Please sign in to leave a comment.