Custom Report Edit Page:
Views
Tab for a Grid View

The
Advanced Formatting
tab lets you set up advanced formatting for the grid view of the custom report that you create or modify.
The process for setting up advanced formatting includes creating formatting rules for the appropriate result columns. For each formatting rule you need to specify the HTML tagging that the rule applies to the results. If the formatting rule is conditional on some data values, you need to specify the appropriate conditions. For example, in a computer disk space report, you may want to apply the formatting rule only to computers that have less than a specified minimum free space remaining. The rule would be conditional on the free space value being less than a specified amount.
Options on the
Advanced Formatting
tab
Option
Description
Rule Name
Lets you specify the rule name.
Format Type
Lets you specify the format type of the report.
Applies To
Lets you specify if the HTML formatting in the template applies to the entire grid row or to the selected column only.
Each data column in the report results is listed. If the report results include items, the ItemGUID column is also available. This column is hidden from all views, but is included in the query results.
Conditional
You can set up conditional statements within formatting rules to make the rules apply only to particular data values. For example, you may want to highlight certain data values in the grid, or identify any missing data values.
If you want to set conditions on the formatting rule, check
Conditional
.
Under
Condition
, you can set conditions for the formatting rule:
  • Column
    Specifies the column to which the condition applies. Each data column in the report results is listed.
  • Check
    Specifies the conditional operator.
  • Value
    and
    Value 2
    Specifies the value or values that the operator uses to check the condition.
Format
Lets you set up the appropriate formatting template fields:
  • Source Value
    Specifies the source of the data that is shown in the formatted cell. The default is Applied Value, which is the data that is already in the cell. However, you can replace that with any other data from the same row, by selecting the appropriate column. Each data column in the report results is listed.
  • Source Type
    Specifies the source value type to display.