From version 3.8.0
This page describes behaviour available from client version 3.8.0. Sites on an earlier version do not have it yet.
Emailing a saved report on a schedule¶
Have a saved report run again and sent to you every day, week or month.
Requires: the report must be
- yours: only the owner can schedule a report, and only the owner receives it;
- private: a published report cannot be emailed;
- saved with relative dates, so each email covers a new period;
- from the Rebate Report Builder, the turnover Report Builder or the Turnover queries list. Other screens cannot be emailed.
The site must also have the daily saved report email task set up in the task scheduler. Without it nothing is sent.
Steps¶
When saving or updating the report:
- In the Save Report dialog choose Relative to when it's run.
- Switch on Email this report to me.
- Set How often: Every day, Every week (choose the day of the week) or Every month (choose the day, 1 to 31).
- Set Include: the table in the email plus a spreadsheet, the spreadsheet, or the table only.
- Choose Save report.
For a report already saved:
- Open Saved reports → Manage saved reports.
- Choose the envelope button on the report's row.
- Set Send, the day and Include, then choose Save.
The row shows a badge such as Weekly on Monday or Monthly on the 1st.
Result¶
On each due day the report is run as you, with your permissions and with its dates worked out for that day, and sent to the email address on your contact record.
- The email is from site name Reports, with the report name as the subject, the period covered (for the two report builders), and an Open this report button.
- The table in the email shows up to the first 25 rows and 8 columns, plus the total row. The attached spreadsheet holds the whole report.
- A monthly report set to a day the month does not have (the 31st in a 30-day month, or the 29th to 31st in February) is sent on the last day of the month.
- A report is sent at most once a day. The time of day is the time set on the site's task.
- A report with no rows is still sent, saying it returned no rows for the period.
Stop or change the emails¶
Choose the envelope button on the Manage saved reports page and set Send to Not scheduled, or switch Email this report to me off in the Save Report dialog.
The schedule is also cancelled, without a message, when:
- an administrator publishes the report;
- the report is saved again with fixed dates;
- the report is deleted.
If it fails¶
- No "Email this report to me" in the dialog: the dates are fixed, Publish to everyone is ticked, or the screen cannot be emailed. The dialog says which of the first two applies.
- The envelope button shows a message instead of opening: the report is public, has fixed dates, or is from a screen that cannot be emailed.
- No envelope button: the report is not yours.
- Nothing arrives: check that your contact record has a valid email address, that the day and frequency are right, and with an administrator that the site's saved report email task is scheduled and ran. The task's run in the scheduler lists each report that failed or was skipped and why. A report that fails on its due day is not sent again until its next due day.
- The email says the spreadsheet could not be attached: the table in the email is still complete up to its row and column limit; open the report for the rest.