Applies to: every logisticaHQ Tenant, from release 2.56.67
Roles required: office Users. Activate and Deactivate on the list are shown to an Administrator only, like New and Delete; the Active switch is on the report's own screen. Client Users cannot open Scheduled reports.
A scheduled report runs its query on a schedule and emails the rows as an Excel file to its recipients. Until release 2.56.67 the only way to stop a report from going out was to delete it, which also threw away its query, its schedule and its recipients.
From 2.56.67 every scheduled report has an Active switch:
Active (on): the report is emailed on its schedule, as before.
Not active (off): the report is kept, with its query, schedule, Clients and recipients untouched, but it is not emailed on its schedule. Nothing else about it changes, and it can be switched back on at any time.
You can switch one report on its own screen, or many reports at once from the list.
The words to know:
Active: whether the scheduler sends the report on its schedule. Shown as the Active column on the list and the Active switch on the report.
Activate / Deactivate: the two buttons that switch every ticked report on or off in one click.
Run: the button on the report's screen that sends the report once, now, whatever its schedule.
What happens to a report that is off
Situation
Report on
Report off
Its scheduled time comes
It is emailed
It is not emailed and nothing is logged as sent
Someone presses Run on its screen
It is emailed once
It is still emailed once: Run is a deliberate request
Its query, schedule, Clients, recipients, subject, body
Kept
Kept, unchanged
Execution plan on its screen
Lists the next times
Lists the next times it would run if switched on
It is switched back on
—
It waits for its next scheduled time; the runs it missed while off are not sent
Why the missed runs are not sent: a report switched off for a week would otherwise send seven daily emails the moment it is switched on. While a report is off, the scheduler still notes the time it last looked at the report, so switching it on starts cleanly from the next scheduled time.
Navigation
Open Setup > Reporting > Scheduled reports. The list shows every scheduled report with its Name, Description and Active. Active shows a green Active pill for a report that is on and a grey Inactive pill for one that is off.
Click a report's name to open its screen. The Active switch is the first field of its Query tab.
On the Query tab, the first field is Active. It shows Yes when the report is on and No when it is off.
Click the switch to change it.
Press Update. Nothing is saved until you do: leaving the screen without Update keeps the report as it was.
The hint under the switch repeats the rules: "The report is emailed on its schedule. Off: it is kept but not sent; turning it back on waits for its next scheduled time. Run still sends it once."
Tick the reports to change, with the box at the start of each row. The bar above the list shows how many are ticked and offers only the buttons that would change something: Activate when at least one ticked report is off, Deactivate when at least one is on, and Delete.
Click Deactivate to switch every ticked report off, or Activate to switch every ticked report on. It happens at once, without a question, because it is undone the same way.
The ticks are cleared and the list reloads, so the Active column shows the new state.
Good to know:
A report that is already in the chosen state is left as it is. Ticking three reports of which one is already off and clicking Deactivate changes the other two. When every ticked report is already on, Activate is not offered at all, and the other way round.
Delete is still the red button, last in the bar. It asks first and removes the reports for good; use Deactivate to keep them.
While the change is being saved, the three buttons are greyed out, so a second click cannot send it twice.
Finding the reports that are off
The Active column can be sorted and filtered like any other column:
Click Filters above the list to show the filter row.
In the Active column of the filter row, choose No to list only the reports that are off, Yes for those that are on, or All to show every report again.
Click the Active header to sort, so the reports that are off come together.
The Active column is part of the list's layout: it can be hidden or moved with Columns like the others.
Drafts: a new report without a query (2.56.87)
New asks only for a name and a description, and the query is written on the report's own page. Until a report has a query it is kept as a draft that never sends. Before version 2.56.87 every new report was refused with Write a SELECT query to run.
New reports and reports from before 2.56.67
A report created with New starts on. Its schedule and recipients are set on its screen, as before.
Every report that existed before 2.56.67 is on after the update. Nothing stops being sent because of the update.