This documentation supports the 19.02 version of Remedy IT Service Management Suite.

To view the latest version, select the version from the Product version menu.

Fields

  1. Locate the fields you wish to use either by;
    1. Keyword Search at the top of the View Fields List
    2. Opening the field categories they are located in
  2. Select the field by clicking on it. If you have multiple fields to add hold down the Ctrl or Shift keys while selecting the fields.

    Info

    • (For Microsoft SQL Server database) When adding an nText type of field to a report, do not use an aggregate field or DISTINCT data type. Otherwise, the following error is displayed:
      An exception occured: ERROR (552): The SQL database operation failed.; The ntext data type cannot be selected as DISTINCT because it is not comparable.. Please check the SQL syntax and try again.
      Also ensure that you select the Show Duplicates option to avoid an error. A list of nText fields is available here.

    • (For Oracle database) When adding a Character Large Object (CLOB) type of field to a report, do not use an aggregate field or DISTINCT data type. Otherwise, the following error is displayed:
      An exception occured: ERROR (552): The SQL database operation failed.; ORA-00932: inconsistent datatypes: expected - got CLOB . Please check the SQL syntax and try again.
      Also ensure that you select the Show Duplicates option to avoid an error. A list of CLOB fields is available here.



  3. You will now see a preview of the table. Continue adding fields as required.

Removing fields

  1. Select the field in the Columns/Rows list it's placed in, open the drop down menu and select Delete.


  2. Select the field in the Columns/Rows list it's placed in, and drag it to an area of the page that cannot contain a field. 

Reordering fields

  1. Select the field in the Columns/Rows list it's placed in, and drag it to its new position.
  2. Select the field header in the Table Preview area, and drag it to its new position.

Field types

The fields available in the BMC Remedy Smart Reporting semantic views list are mapped to the fields existing on the AR system forms. Some of the field names in the views list do not match with the field names in the AR forms. To know the field mapping, see field mapping details.

TypeDescription
DimensionThese are typically text or date fields and are used to describe the data.
MetricThese are the numeric values to be measured in the report. For example, sales sum, customer count, event count, average age.
Pre-defined filterThese are fields defined in the view to be used as filters in the report with pre-defined values attached, saving the user time defining the same filters over multiple reports.
Filter GroupThese are like the pre-defined filters above, but are sets of filters, some of which may be set to user prompt rather than having set values.
ParameterThese are fields used to capture a value from the user which is then passed through to calculated fields or filters in the report.

Layout options

LayoutDescription
ColumnThe most common form of table output, all fields added are displayed as a column in the table layout, with the field name used as the column header.
RowA variant the column layout, all fields added are displayed as a row in the table layout, with the field name used as the row header.
Cross TabA special layout that allows you to summarize data by using both Column and Row headers with Metric fields making up the body of the table. This display is sometimes referred to as a Pivot.

See Table layouts for more information.

Data validation

See Constraints and semi additive fields for more information.

Was this page helpful? Yes No Submitting... Thank you

Comments