0

Weeknumber in filename

Jet Reports Historic Posts

October 16, 2012 13:04

None

Follow

Hi,

I would like to include the weeknumber in my filename when using autopilot.

Now we can only use
%YEAR% Current year, four digit
%MONTH% Current month, two digits
%DAY% Current day of the month, two digits
%HOUR% Current hour, 2 digits, 24 hour clock
%MINUTE% Current minute, 2 digits.

Can I use a named range for the filename?

• Facebook
• Twitter
• LinkedIn

5 comments

• 
  Jet Reports Historic Posts October 17, 2012 16:02 Official comment

  No no, nothing like that. You are constructing the values for the autopilot commands in Excel. You can use Excel functions to construct the AutoPilot commands to have whatever filename you want including the week numbers. I will attach a simple example of the report you will schedule which has the batch line in it. Also, there is an article in the Jet help on the AutoPilot command line switches here:
  
  http://help.jetreports.com/12.5/Essentials/AutoPilot%20Command%20Line%20Parameters.html
  
  Does this help?
  
  Regards,
  Hughes

  • Batch Example.xlsx
• 0
  
  Jet Reports Historic Posts October 16, 2012 15:06

  Hi Robbie,
  
  Sorry, the only replacement strings that are allowed are those listed and you can't use a named range for this. You could create a feature request for this, but currently it's not possible.
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts October 16, 2012 15:09

  Actually, come to think of it, there is a way to do this, just not directly. You can create a report which is a batch file which runs a bunch of AutoPilot commands defined in an Excel named range. Then you can construct the output filename using Excel functions and include the week number. Then you schedule the batch report and use the Batch File Generation (/X) function to run the batch. Does that help?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts October 17, 2012 08:43

  Thanks you for your suggestion. I saw that I can only use Dos commands or Jet autopilot commands in the named range. So how would I be able to incorporate the value of a cell? Do I need to enter a Dos rename command? ren filename1.xlsx "filename" & $D$4 & ".xlsx"
  I really can't find any tutorials/samples on the /x feature.

• 0
  
  Jet Reports Historic Posts October 17, 2012 20:33

  Hi Hughes,
  
  Thanks for your answer. That makes sense. Will try that out tomorrow at work.
  Will let you know the result.
  
  Regards
  
  Robbie