Hello,
I am attempted to batch schedule a report that has three parameters. They are company 1, company 2, and a date.
I am using the command line where:
A. There are as many rows as have countries.
B. There ranges and values are as follows:
Range1 = ReportDate - named range in the report
Value 1 = Date
Range 2 = HybridCompany - named range in the report for company 1
Value 2 = the value associated with the "HybridCompany" named range
Range 3 = LiveCompany - name range in the report for company 2
Range 3 = the value associated with the "LiveCompany" named range
When i go to schedule the report instead of spitting out as many reports as I have command line rows for with the above parameters it just drops the actual scheduler into the output folder. I know I'm probably missing something small that is breaking everything so I wanted to drop this on the forum instead of spending hours…
Thanks!
Thomas
Date
Votes
4 comments
-
Jet Reports Historic Posts Hi Thomas,
You have to create a named range which includes all your AutoPilot command lines. Then in the Scheduler, on the Output tab under Batch File Generation, you have to select the named range which has all the command lines you want to execute. Does this help?
Regards,
Hughes -
Jet Reports Historic Posts Hey Hughes,
You create this named range in design mode when everything is just one line correct?
If so, I already have one which is command line column/row E8 to AG9.
I was just confused as to why the batch template is running itself. What causes that?
Thomas -
Jet Reports Historic Posts Thomas,
The batch template always runs itself. That's just how AutoPilot works. If it didn't run the batch workbook, it wouldn't expand the replicators, etc. If you have specified your batch range and it has valid AutoPilot commands in it, those should get run as well after the batch report is run. Is that not the case?
Regards,
Hughes -
Jet Reports Historic Posts Okay. Just didn't know if it was supposed to generate itself or just the reports in the command line. Now that I know it's supposed to generate itself then I know what to expect.
Thanks for looking at this!
Thomas
Please sign in to leave a comment.