Hello
I am trying to run a simple batch from an excel file for a jet report created with jet essentials. My main question is, to get the scheduler to generate the command lines correctly, is it necessary to include an NL or similar jet formula in the named range in the batch file, as per the example, or can you manually create each line with the desired inputs? I've tried manually recreating the exact same set of inputs for the scheduler, and can only get it to run the first line in the batch then it simply ends the task in the scheduler. There seems to be some eratic behavior in the schedulers response to different ways of creating the information for the batch range in the excel sheet, for instance, if i create the range with an expanded rows NL formula, it only runs the first line, if i do the same and add a manual entry below the last automatically generated row and include it in the batch range, it runs the whole set. If anyone has experience with the scheduler, could they point me towards some information about how this works?
Thanks
Jamie
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Jamie,
So the goal for the batch range in your batch report is that after the report is run, the named range will encompass all the rows with AutoPilot commands on them. So if you're manually creating the lines and not replicating them with NL(Rows), then you need to create the named range around ALL the rows you want the Scheduler to execute, not just the first row. It's only running the first row probably because you only have the named range on the first row and it needs to include all the rows that will be run.
In terms of creating the rows with an NL(Rows) function, if the named range is just the first row, then it will still only be the first row after the report is run. If you want the named range to expand when the report runs, you have to include an extra row under the row being replicated (this is called an anchor row). The extra blank row will just be ignored by the Scheduler since it will not have a command on it.
You can easily test this in Excel without using the scheduler at all by just creating an NL(Rows) function and creating one named range that only includes the NL function and another named range which includes both the function and the cell underneath it. After you run the report, you can see the the named range which only included the single cell is still only a single cell, whereas the one with the anchor row will expand to include all the replicated cells.
Does this make sense?
Regards,
Hughes
Please sign in to leave a comment.