| 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.
...