Running and Scheduling Reports

Running Reports

All reports run through the reporting module support the following inputs:

Values for each of the parameters that the Report Definition requires. These values may be either fixed, or may be specified as compatible runtime expressions. Runtime expressions are currently limited to the following:

Name

Description

$

Unknown macro: {now}

The exact date/time that the report actually runs

$

Unknown macro: {start_of_today}

The same as $

, except with the time set to midnight at the start of the day

$

Unknown macro: {end_of_today}

The same as $

Unknown macro: {now}

, except with the time set to the last millisecond of the day |

$

Unknown macro: {start_of_last_month}

Relative to $

, this is midnight on the first day of the preceeding month

$

Unknown macro: {end_of_last_month}

Relative to $

Unknown macro: {now}

, this is the last millisecond of the last day of the preceeding month |

$

Unknown macro: {generatedBy}

The user who requested that the report be run

$

Unknown macro: {generationDate}

The date that the report was generated, usually the same as $

Any of the above expressions that return Dates can also contain date "arithmetic". For example, let's say you have a report that takes in 2 parameters named "startDate" and "endDate". If you want to run a Report that covers the previous week, you could specify: startDate = $

Unknown macro: {start_of_today-7d}

and endDate = $

Unknown macro: {end_of_today-1d}

. The arithmetic supports expressions in the format of either "+" or "-", followed by a number, followed by the units (either d (days), w (weeks), m (months), y (years), h (hours). You can also have multiple expressions together. So, you could have $

Unknown macro: {now-5d+2w-5m+6h}

and this would evaluate to a particular date.