Variable Descriptions

Variables are used to insert report parameters into the title and footer fields of the reports. You may use the Click to add variables button to insert the variables below or manually type the variables into the title or footer fields.

Table 2-14: Understanding Variables

Variable

Description

{Date}

The date the report was generated in MM/DD/YYYY format (e.g., 10/30/2010). If you would like to change the date format, specify the format parameters after the pipe character (|). The parameters are case sensitive. For example:

{Date|dd-MMM-yyyy} produces 30-Oct-2010.

{Date|MMMM dd, yyyy} produces October 30, 2010.

{Date|dddd MM, dd, yyyy} produces Saturday Oct. 30, 2010.

{DateRange}

The time period covered by the report, as specified in the Date Range section (Selecting a Report's Date Range). The format for this variable is [date_field] is within [selected_date_range] (e.g., IncidentClosedSee Event Date is within Calendar 2010 Q1).

{Expression}

The filters added to the report in the Conditions section (Report Conditions Section). The format for this variable is [field_name] [operation] “[entered_value]” (e.g., Type is equal to “Clinical Administration”).

{Field}

This variable requires you to specify the field ID (Locating Fields) and the field attribute you would like to display. The parameters are case sensitive. For example:

{Field|1014|Caption} produces Location ID.

Note: To locate the field ID, use the Field list in the Conditions section. Hover over a value in the list and look at the browser’s status bar: the field ID is at the end of the address, after the #F (Locating Fields)

{Filter}

Includes both DateRange and Expression filters. The format for this variable is ([DateRange]) and ([Expression]) and ... (e.g., (Incident Date is within Calendar 2010 Q1) and (Type is equal to “Clinical Administration”)...).

{Time}

The time the report was generated in the HH:MM AM/PM format (e.g., 06:33 PM).

{TimeZone}

The time zone of the user who generated the report.

{Module}

The module from which the report was generated.

{User}

This variable requires you to specify whether you want to display the user’s name or email address as a parameter. The parameters are case sensitive. For example:

{User|Name} produces Mark Borchardt.

{User|Email} produces mark.borchardt@northwestern.com.

Simply entering {User} will display the following in the report: {User syntax error}. The user variable must specify which attribute, {User|Name} or {User|Email}, should be used.