Schedule Reports
Have these permissions:
- custom.reports.schedule.adminto update report schedules owned by other users.
- custom.reports.settings.adminto modify Report Settings in all reports.
- custom.reports.adminto see and modify report schedules saved by other users.
Scheduling reports enables you to generate reports on a set schedule. Example: Every Monday morning, the finance team needs to review the total spend of all contractors for the previous week. Instead of manually running the Master Spend Report every Monday at 8:00 am, they set up and automated schedule.
When scheduling reports, you can have them delivered by email or SFTP. To have a scheduled report delivered by SFTP, contact the VNDLY Support team to have the SFTP location configured in VNDLY. Currently, SFTP endpoints are only available to administrator and MSP users.
VNDLY can only schedule a report that is saved.
After scheduling a report, you can choose to run the report now for ad-hoc reporting between the scheduled dates. Only the Schedule Owners can perform this task.
- Navigate to theReportspage.Depending on your permissions, you can access this page directly from the VNDLY header or in the drop-down menu.
- Open the report that you want to schedule.
- On theSettingstab, in theSchedulingsection, clickAdd Schedule.
- UnderSchedule Details, consider:
Option Description Schedule OwnerDefaults to the name of the person creating the schedule. Users that are available for selection in the drop-down must havecustom.email.scheduleand either thecustom.email.scheduleorcustom.sftp.schedulepermission.FrequencyInterval at which the schedule report should run.Start DateThe first day the scheduled report frequency should run.End DateThe last day the scheduled report frequency should run.Scheduled TimeTime of day the scheduled report should run.TimezoneTimezone for the schedule. - UnderFile Options, consider:
Option Description Send report even if there is no dataWhen checked, the scheduled report is run and delivered even if the report returns no data.Include report creation details in report headingWhen checked, the report heading displays report creation details.Include column headersWhen checked, the generated report includes headers.Export FormatFile type of the generated report.File ExtensionDefaults based on the selectedExport Format.Remote File NameName used for SFTP uploads, email, and report history. - UnderReport Delivery, consider:
Option Description EmailWhen checked, the generated report is delivered by email on the scheduled date. Recipients receive a link to view the generated report in VNDLY.Include report as an attachmentWhen checked, generated reports are delivered by secure link, as well as an attachment to the email.Email RecipientsEnter the names of the recipients who should receive the scheduled report email.SFTPWhen checked, the files are delivered to the configured SFTP destination.To select the SFTP delivery method, you must have SFTP endpoints configured on VNDLY. To configured endpoints, contact the VNDLY Support team.SFTP DestinationThe location where the files are delivered.Remote Folder PathThe folder path where the file is stored in the server. - ClickCreate Schedule.
All newly scheduled or Run Now reports are logged under the
Report History
tab on the Reports
page. Click Download
to access your files.