Edit report

General

Primary key. Read-only on edit.

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

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)

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 subject

Defaults to report Name if blank.

Sender email

Recipients (CSV)

Cancel

Status (read-only)

Last attempted run

2026-08-01 06:03:54

Last successful run

2025-10-01 06:05:17

Failures since last success

Last error message

Error: Connection request timed out StackTrace:    at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)
   at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)
   at OracleInternal.ConnectionPool.OracleConnectionDispenser`3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString securedPassword, SecureString securedProxyPassword, OracleConnection connRefForCriteria)
   at Oracle.ManagedDataAccess.Client.OracleConnection.Open()
   at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
   at Oracle.ManagedDataAccess.Client.OracleDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand

Run on next poll