Scheduled Reports
New report
General
Id
Leave 0 to auto-assign max + 1.
Name
Code
Short code used as Excel worksheet name (max 31 chars).
Description
Active
Data source
SQL query
Connection string name
Must match a key in the worker's appsettings ConnectionStrings section.
Database type
mssql
oracle
PowerShell
PowerShell script (before)
Runs before the report SQL. A non-zero exit code fails the run.
PowerShell script (after)
Runs after the report email is sent. A non-zero exit code fails the run.
Schedule
Hour of day (0–23)
00:00
01:00
02:00
03:00
04:00
05:00
06:00
07:00
08:00
09:00
10:00
11:00
12:00
13:00
14:00
15:00
16:00
17:00
18:00
19:00
20:00
21:00
22:00
23:00
Missed-schedule threshold (minutes)
Days of week (leave all unchecked for every day)
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Days of month (CSV)
Output
Send as Excel attachment
Send as HTML in email body
Send empty report
Filename format
Filename date offset (days)
Email body HTML template
Use
{TABLE}
as a placeholder for the rendered HTML table.
Email
Email subject
Defaults to report Name if blank.
Sender email
Recipients (CSV)
Save
Cancel