Highlight is a visual indication on an ad hoc report. The purpose of highlighting is to catch user’s attention to specific records or groups while viewing the report output. Each highlight is configured along with an ad hoc condition or multiple conditions related by AND/OR operators. The specific record or group is highlighted only if the specified condition is satisfied.
You can also specify Alert with or without highlight. Setting alert creates a special head listing the record count for mentioned condition(s) in the report.
You can set multiple highlights on a report; a record falling into multiple highlights will be highlighted in combination style.
A highlight can be set at Detail level or Report level. If the report is grouped, highlight can be set at group level too.
Figure 9: Setting highlighting
Highlighting properties
Item | Values | Comments |
Highlight | Select from list: (Entire Row)
Group->Field Name(Entire Row)
Field Name |
(Entire Row) = Apply below mentioned highlighting style to entire row of detail.
Group->Field Name(Entire Row) = Apply style to entire row of field under group header
Field Name = Apply style to individual field value |
Using Style | Select from list | Select the style (combination of color and image) to apply on highlighting item You can select Custom Style in order to create highlights of your choice of font style and color. |
Alert | Check/Uncheck | Check = In addition to applying style on the report item, the report tool bar also shows an alert icon, if a highlight condition occurs. When this report is saved, users can subscribe to this alert from notification screen Uncheck = visual style applying only |
Open | ( (( ((( (((( ((((( | Braces to group more than one conditions using AND/OR |
Field | Select field from list | Field to apply condition on |
Level | Select field from list:
Detail Report
Group |
Detail = field’s value to be compared at row level Report = field’s value to be aggregated at report level and then compared Group = field’s value to be aggregated at mentioned group level and then compared |
Function | Select from list Sum, Avg Count, Min, Max, Variance, PopVariance, StdDeviation, PopStdDeviation and Distinct functions | Aggregation function, used in case of field level is Report or Group |
Criteria | Select from list | Condition like Above, Below, Is etc. to apply on the specified field |
Use Field | Check/Uncheck | Check = The value box turns into a field selector. Helps in comparing one field with another for the condition (Comparison is done dynamically at run time) Uncheck = The value box shows text box, select list or calendar to manually enter or select values (Comparison is done on static value defined at design time) |
Value | Enter or select value | Shows text box, select list or calendar to manually enter or select values from drop down list in case “Use Field” is checked |
Close | ) )) ))) )))) ))))) | Braces to group more than one conditions using AND/OR |
Relation | AND
OR | AND = The next line condition relates to this condition with an AND operator. This is default behavior when blank is selected OR = The next line condition relates to this condition with an OR operator |