Documentation for CXO-Cockpit Reporting Suite 5.0, click for CXO-Cockpit Reporting Suite 4.3 Documentation or check the CXO-Cockpit Website.

Rows List

From CXO Cockpit Reporting Suite Documentation
Jump to: navigation, search

Introduction

A rows list is a list building block that can be used for formatted statements. This type of list supports all types of formatting and is used for example on:

List Attributes

Basic Attributes

List Attribute Default Description
Empty No By setting this attribute to yes, the line will be shown as empty. This means that no data will be queried and only the label/custom description will be showed.
Visible Yes By setting this attribute to no, the line will be hidden. Hiding a line can be useful for a calculation step in a formula.
Custom Description Empty The custom description overrides the default generated name. You can use either a fixed text or a Dynamic Label Expression
Formula Empty By specifying a formula this line will be calculated.
Format Default Format The format will specify the look and feel of the row.
Order Max + 1 Use the order attribute to reorder the rows.

Advanced Attributes

List Attribute Default Description
Header Format Default Format The format will specify the look and feel of the row header
Drill Empty By assigning a drill list to a row, a drill icon will appear in front of the line in the report. This drill list allows the end-user to drill to that list.
Reverse Valuation No When this attribute is set to yes, the Valuation will be reversed. This means negative becomes positive and the other way around. Changing the valuation will influence the variance coloring.
Reverse Sign No When this attribute is set to yes, the sign will be flipped.
Suppress Value None This value sets automatic row suppressing, click on the type to see the suppressing options. 
Variance Threshold Empty Threshold value for the Variance (e.g., Actual vs. Budget). If the Variance is less than this Threshold, then a neutral variance color is used (Orange). Otherwise Red (indicating an unfavorable variance) or Green (favorable variance) is used. Use e.g. -200;300 for an absolute threshold or -10%;20% for a relative threshold.
Suppress Variance SuppressNoBaseOrReference Allows you to set the conditions for not suppressing the Variance, by using a pick list