Set up report jobs

If you want to create reports automatically, you must set up a report job. This generates a report at regular intervals based on a template and stores it in the document management system.

To create a new report job, proceed as follows:

  1. Go to document management by clicking on Documents in the user menu at the top right.

  2. Select a valid document template. Avelon Reporting currently supports the following formats:

    • Microsoft Word document (*.docx)

    • Microsoft Excel workbook (*.xlsx)

    • Microsoft PowerPoint presentation (*.pptx)

  3. Click on Configure Report Jobs on the right sidebar next to Report Jobs. This function is only available if the selected file has a valid template format according to step 2.

  4. In the following dialog, you will see a list of all report jobs that have been set up for this template on the left-hand side.

  5. Click on Add Job at the bottom left.

  6. Configure the new report job:

    Name

    The name of the report job as it is to be displayed in the dropdown. Reports created by this report job are automatically given this name followed by the report creation date.

    Schedule

    The schedule according to which reports are to be generated.

    • Annually (every 1st of January)

    • Biannually (every 1st of January and 1st of July)

    • Quarterly (every 1st of January, April, July and October)

    • Monthly (every 1st of the month)

    • Weekly (every Monday)

    • Daily

    • Custom: Enter the desired schedule in the CronTrigger format

    Note

    Note that the schedule does not affect the data contained in the report. When creating the report, the widget and the time interval configured on it will be taken into account. Please make sure that this time interval is aligned with the schedule of the report job.

    Output Format

    Decide whether the generated reports should be created in the same format as that of the template (e.g. as a Word document) or as a PDF instead.

    Output Folder

    Select the folder in which the reports are to be stored by default. The reports can then be retrieved via the document management system.

    Send report by email to:

    You can also have the system automatically send the generated reports to users. Activate this option and add the desired users to the list. You can enter additional users using the user management.

../_images/report-job.png

The sidebar editor for report jobs

Note

You can create any number of report jobs for each valid template file. In most cases, however, a single job is sufficient.