How do I update the options tab in auto pilot? Currently, I have the formula below in the bat file that isn't working.
"%ProgramPath%" /m %Mode% /i "%BasePath%\%InputPath%" /o "%OutputPath%\1000_AA" /p "Dept" "1000" "Project" "*"
This string of the above formula -/p "Dept" "1000" "Project" "*" - is what is not working. I can't get the Jet Report in the output folder to update its options with that information. Dept and Project represent Excel cells in the options tab of the Jet Reports input file.
Thank you for your assistance!
Ashley
Date
Votes
5 comments
-
Jet Reports Historic Posts Official comment Ashley,
I looked at your input report and it looks like the named range "Project" is a #REF! (just look at the Excel name manager). The actual named range on the Options sheet is called "proj". There are actually a number of named ranges on the report which are #REF which could mess things up. I went ahead and deleted these from the report and am attaching it. You will need to change your command line to use the "proj" named range though since the Project one is gone. Does this help?
Regards,
Hughes -
Jet Reports Historic Posts Hi Ashley,
Have you made the appropriate options cells you want updated Excel named ranges with the names Dept and Project?
Regards,
Hughes -
Jet Reports Historic Posts Hughes,
Yes, I have. In the older version of JetReports, these options would update, but they don't in latest version of JetReports.
Thank you for your help!
Ashley -
Jet Reports Historic Posts Hughes,
Here is my input Jet Report.
Ashley -
Jet Reports Historic Posts Hughes,
Thank you. I had not noticed the #REF. The report works now.
Ashley
Please sign in to leave a comment.