QAD 2017 Enterprise Edition > User Guides > Reporting Framework > Administering Reports > Report Settings
  
Report Settings
When a report is run, the system uses a set of report settings that determine the behavior of the report run. Some settings are just set and used internally by the system, others are exposed for users to set in the report viewer, and some can be passed in when using the QAD Reporting Framework API to run or schedule reports from another software program. Many of these settings are also useful to reference in dynamic variables that can be used when configuring e-mail templates, dynamic output file names, and dynamic output file paths.
This section describes the main report settings that are important for general use of the system.
Note: There are also a set of special settings used only for report bursting. These are described in Running a Report Burst.
sys_attach_to_email
If set to true, the report output file is attached to any e-mail notifications. When set to false, no attachment is created. (Applies only to scheduled reports.)
sys_base_currency
Specifies the base currency to use for the report (for example, USD).
sys_ci_date_separator
Specifies the separator character to use for date formats (for example: /).
sys_ci_decimal_digits
Integer value that specifies the number of decimal values to display after the decimal point for numeric values.
sys_ci_decimal_separator
Specifies the character for the decimal point (for example, . or ,) for numeric values.
sys_ci_group_separator
Specifies the character to use for the thousands (for example: ,) for numeric values.
sys_ci_group_sizes
Specifies the number of digits to use for grouping digits in numeric values. For example, in the United States, three digits is a group for thousands, millions, and billions.
sys_ci_short_date_pattern
Specifies the .NET short date format string used for formatting date values. For example: M/d/yyyy.
sys_default_report_definition
Specifies the name of the report layout definition to use for report rendering. If not specified, then the default layout definition is used.
Note: The name of this parameter can cause confusion: this setting does not specify the default layout, but rather the layout to use for this report run. Example: SimpleItemReport.
sys_domain
Specifies the database’s domain to use for the report query.
sys_email
Specifies a comma-separated list of e-mail addresses to which report notification e-mails are sent. (Applies only to scheduled reports.)
sys_email_template
Specifies the e-mail template to use for report notification e-mails, as described in Modifying the Scheduled Report e-mail Template. If not specified, the system default e-mail template is used. (Applies only to scheduled reports.)
sys_entity
Specifies the entity to use for Enterprise Financial report queries.
sys_filter
Specifies the name of a saved filter (set of user-defined report settings) to use for the report run.
sys_inbox
Specifies a comma-separated list of user IDs to whose QAD .NET UI InBox report notification messages are sent. (Applies only to scheduled reports.)
sys_language
Contains the ISO locale code used for report label translations (for example: en-US). Set by system; to manually set a specific language, use the sys_mfg_language setting.
sys_link_to_email
If true, a link to the report output file is contained in the body of report e‑mail notifications. (Applies only to scheduled reports.)
sys_mfg_language
Specifies the system language code to use for report label translations (for example: us).
sys_output_file_name
Specifies a format for the report output file name. For example: {$DATE_TIME}.
sys_output_file_path
Specifies the file directory path in which to save report output files. For example: {$RRO_CATEGORY}/results/{$RRO_CODE}/{$USER_ID}.
sys_printer
Specifies a UNC printer name for printing the report output. (Applies only to scheduled reports.)
sys_render_as
Integer value that specifies the report output file type used for rendering, as follows:
1 — PDF
2 — Excel
4 — Plain Text
5 — PDF Protected
6 — RTF
7 — TIFF
sys_save_output
If true, then the report output file is saved on the home server. (Applies only to scheduled reports.)
sys_search_criteria_display
Integer value that specifies the location of the system-generated search criteria section in the report output.
1 — Footer (default)
2 — Header
3 — None
sys_trusted_signon_session
Contains the user ID of the user running this report.
Note: For scheduled reports, this is the user ID of the user who scheduled the report.