This is probably something simple, but I can't see a simple solution..
I have a report that runs daily, but each day the output file overwrites the previous one, sometimes I need to refer back to previous output files to see the state of play on a certain date.
Is it possible to set the output file to save under a new filename each day?
Ideally I would like to prefix the filename with the date of the report..
Eg. 20171115_ Report.xls
Thanks
Hello Simon,
You can use AutoPilot Command Line Substitutions to add a Day/Month/Year/Hour/Minute to your file name in order to uniquify it.
You can do that or you can create separate folders for each day using the same AutoPilot Command Line Substitutions.
AutoPilot Command Line Substitutions: https://jetsupport.jetreports.com/hc/en-us/articles/219402367
e.g.
C:\Users\MSW\My Documents\Output\MyFileName - %Year%-%Month%-%Day%.xlsx
or
C:\Users\MSW\My Documents\Output\%Year%-%Month%-%Day%\MyFileName.xlsx
I have noticed an issue on some Windows Server 2012 machines where the AutoPilot Command Line Substitutions will not work correctly if you are reading from and saving to a network share but will work if you are reading from and saving to a local directory.
Hope this information helps.
Regards,
Sanket
Thanks! that's just what I was looking for!