Hi
As title says - I want to create a batch schedule that will loop through and update the values in the 2 fields (in my case it is state and business name). This will result in 12 reports (one for each state and business name)
Suppose I actually have 2 questions:
1) As the business names and states will never vary - is it possible to set the BatchRange in the command sheet to simply reference a static table? As per the tab 'Static Named Range' or does the command sheet have to be generated by a Jet Report?
2) How do I get the scheduler to update each report by changing 2 fields each time (both of them named ranges specified in the report)
Cheers
Date
Votes
1 comment
-
Jet Reports Historic Posts 1) Yes, just don't use replicators. I do it all the time - build a static named ranged called batch with all of the required columns for the running the batch job. The example command line here is helpful:
http://kb.jetreports.com/article/AA-00549/0/Dynamic-Batch-Scheduling-Command-Line-Parameters.html
2) If you'd rather store the parameters in a separate range somewhere, use a VLOOKUP.
Please sign in to leave a comment.