Need to download a Fluid report daily, weekly or at specific time? Application administrators can schedule reports to be downloaded at regular intervals and to be emailed or dropped at a set location.
To set a new scheduled report, navigate to the Administration Console page and then select Scheduled Reports in the System Settings section. Please talk to your account manager if you do not see the Scheduled Reports option as it means it has not been configured on your instance.
Click on Add Item to schedule a report.
You will be presented with the following dialog. Fill in the fields as described below and click Save to save the report.
|Title||Give a title to the scheduled report. Setting a descriptive title helps identify the purpose of the report, especially when multiple reports have been set up.|
|Report Type||Select the type of the report you want to export.|
|Date Option||This field applies to report type that requires a date range, e.g. financial reports. Select the date range you want the report for.|
|Report Format||Select the format you want the report in - Excel, CSV or Tab Delimited.|
|Report Path||Set the location where the report should be sent / saved to. Enter the report path in one of the formats below, depending on the delivery mechanism required:|
|Password||A password may be required depending on the delivery mechanism used.|
|Cron Schedule||Use a Cron expression to schedule the frequency of the report. Please see below on how to use Cron expressions.|
|Report Enabled||Set the toggle to Yes to schedule the report. Set the toggle to No if you no longer want the report to run.|
|Run Once||Set the toggle to Yes if you want the report to only run once and to be disabled after the first run.|
|Query String||Use this field to apply project filters and only export the report for projects that match the filter criteria.|
The best way to find the query string format is to set a project dashboard with the filters you want to apply and then copy the URL query string (anything after the '?' in the URL).
|Execute on Server||Select the server the report should run from.|
|Last Run Date|
Last Run Result
|After the report has been set up, these two information fields will display when the scheduled report was last run and whether it succeeded or failed. This is particularly useful if you need to check the scheduled report status.|