| Wiki Markup |
|---|
{scrollbar} |
The Format Setup step is not required but it is the step where you can really make a report take shape. For each field there is a row of configuration that can be setup.
Report Formatting - Detail
The Display Name text field allows you to enter a human friendly / pretty an "easy to recognize" name for a column. The name POSITIONTITLE might not be all that appealing in a generated report so we can change it to 'Position'. Anytime Any time the column name POSITIONTITLE appears in the report it will be is replaced with ' Position. " In the example shown below, all of the fields have been given a display name. The Null String field is a text replacement which is used when there is no data available. The default is to use the string 'null'.
Expressions are used to create a row of ' summary ' data for a group in its footer. If no expressions are selected, the group footer will be blank and not take up any report real estate. The expression types are filtered based on the metadata pulled for the column. We're not exactly sure what an "average" of a set of strings would look like! For the report we are building in this example give ACTUAL, BUDGET and VARIANCE an expression of "sum." . For each group, we will see a row at the bottom (footer) of the group containing these expressions.
...
Each field has left horizontal alignment by default. Numeric fields will be easier to read and compare if they are right aligned, so adjust ACTUAL, BUDGET and VARIANCE to right. Alignment on groups sets the location of the group in the group header. REGION is out outermost group and it may look more appealing if it is centered. In this example we gave POSITION title right alignment as well. Vertical alignment may also be specified and the default is to be aligned to the middle of the space.
Report Formatting - Group
...