Report Output

DarrenGipson

Hello,

i currently use the Management Console to run around 75 jobs, which run automatically from a period of Daily to Monthly depending on the Report.

Every report is outputted to a folder in a different location under the name of the department the that the report is made for.

The problem is i have to manually then file them concordance to their created date. IE

Sales2008January

Now is there a way of setting up a report output so that it automatically puts a file into the correct folder without me changing the output location every month?

akulkarni

You can specify a date expression for the output report name or folder. In your specific case, you can supply the following as the name of the folder in which you would like the report to be generated.

/Sales/{yyyy}/{mmm}

I have attached 2 screenshots with the first showing the output tab of the job schedule user interface and the second showing the resulting folder structure where the report output is generated.


The syntax for using a date in the output document name or folder is:
name=[valid file name characters][dateformat][name]

Here are a few examples of using a date expression in the folder name and the folder structure created to contain the generated report output document (Sales By Region.rptdocument):

/Sales/{yyyy}/{mmm}-{dd} => /Sales/2008/Apr-04/Sales By Region.rptdocument
/Sales/{yyyy}/{mmmm}/{dddd} => /Sales/2008/April/Friday/Sales By Region.rptdocument
/Sales/{yyyy}/Q{q} => /Sales/2008/Q2/Sales By Region.rptdocument


Here are a few examples of using a date expression in the report output document name:

Sales By Region-{mm}-{yyyy} => Sales By Region-04-2008.rptdocument