REPORTER
Tables
All table objects in Corporater BMP, including Filtered lists and Views in Dataset tables, can be accessed using the Reporter. Use the Template listing menu item to access the Template listing for a table. There will be some table templates there to copy from.
See Benchmarking for information on creating reports with dynamic chart generation.
The table templates for data tables, i.e. the tables that Table views and Charts are based on, can be found in the Template listing for the table in the Templates panel.
The tags in a table refer to the cell they represent, e.g.
-
${Table.143}${A1} is the value of the cell at 1,1 (upper left corner, i.e. the first column of the first row)
-
${B4} is the value of the cell at 2,4 (i.e. the fourth column of the second row)
-
${A1:B4} is the sum of all numeric values in the table range A1-B4, inclusive (as in Excel)
Custom table
The Custom table is the most adaptable of the tables. With this table the report designer has full freedom to include and change the layout of each cell in the table or add additional cells if desired.
Example:
|
${Table.143}${A1} |
${B1} |
${C1} |
${D1} |
${E1} |
Totals |
|
${A2} |
${B2} |
${C2} |
${D2} |
${E2} |
${B2:E2} |
|
${A3} |
${B3} |
${C3} |
${D3} |
${E3} |
${B3:E3} |
|
${A4} |
${B4} |
${C4} |
${D4} |
${E4} |
${B4:E4} |
|
Totals |
${B2:B4} |
${C2:C4} |
${D2:D4} |
${E2:E4} |
${B2:E4} |
could look like this when processed:
|
|
Jan |
Feb |
Mar |
Apr |
Totals |
|
Norway |
851.52 |
871.51 |
693.70 |
810.17 |
3226.90 |
|
Denmark |
840.55 |
850.00 |
700.00 |
836.78 |
3227.33 |
|
Sweden |
843.66 |
902.15 |
757.20 |
832.45 |
3335.46 |
|
Totals |
2535.73 |
2623.66 |
2150.90 |
2479.40 |
9789.69 |
It is also possible to move the cell tags around to pivot the table or have two or more values in same cell.
Expandable table
The Custom table is powerful in that all cells can be changed individually, but it can't handle tables that can be smaller or bigger depending on context. For these tables we use the expandable table tag. This table has less layout functionality but on the other hand it can expand to fit the data table.
Example:
|
${Table.143}${expandable} |
|
|
|
|
This table template has the same table tag as the custom table, to specify what data table to use when rendering. In addition, it has the ${expandable} marker tag that indicates to the reporter processor that this table is expandable.
This table will expand to fit the data table and will show all values in it. If the template table has the same number of columns as the data table, the same column widths as the template table will be used in the resulting table. If the template table has fewer columns than the data table, the table will be automatically fitted to the page width.
Layout of the table is handled slightly differently here:
-
The layout of cell a1 will apply to a1
-
The layout of cell a2 will apply to all cells a2-a*
-
The layout of cell b1 will apply to all cells b1-*1
-
The layout of cell b2 will apply to all cells b2-**
etc.
Example:
|
${Table.143}${expandable} |
|
|
|
Comic font |
|
|
Comic font |
could look like this when produced:
|
|
Jan |
Feb |
Mar |
Apr |
May |
|
Actual |
851.53 |
871.51 |
693.71 |
810.17 |
810.02 |
|
Budget |
777.47 |
873.73 |
863.75 |
964.08 |
915.01 |
In order to format an "empty cell" in an expandable table, you will need to enter any character that will be ignored when the report is generated in the cell
in the template and give it the formatting you want that cell to have in the report.
Expandable tables will use the layout of the text in cell A1 (where the ${expandable} tag is) to determine the text direction to use in the table. E.g. if the text in
cell A1 is written in a right-to-left language, the layout of the entire table will be right-to-left.
The maximum size of tables in the Template mode is 10 in both axes. When the report is generated they will expand normally.
There are some limitations to how status lights and trends can be shown in Expandable tables in Presentations. It is not possible to insert an image into a cell; it
is only possible to set the cell background pattern. This background pattern may be an image, but the only alternatives available are to have is to have the image stretched to fit the cell or have the images repeat to fit the cell (tiles).
Stretch is used in such tables but the size of the image relative to the size of the cell is also calculated. Note that resizing the cell after generation will cause the image to change size.
Row table
The Row table can be used to display the children of any tree object in Corporater BMP. The following example is a Row table that is part of the perspective type Template listing.
The row table is used to display children elements of a tree element in a table. Any table with the ${RowTable.<object>.<list>}tag in cell a1 will be processed by the Reporter processor as a Row table.
The 'rowtable' tag will make a variable 'child' for each child of object 135. The child variable is available for all rows that have the ${childRow} tag. No other rows will be changed except for normal tag processing.
When processing child rows the 'rowtable' will copy the layout of each template 'childRow' in sequence making it possible to have alternating colors for each child.
The ${tableEnd} tag is a marker tag used to indicate to the processor where the last row of the table is. The row with the table end tag will be hidden unless any additional text is put into that row.
Example:
#set(pers,${t.135})
|
${RowTable.pers.speedos} |
Result |
Target |
Status |
Trend |
|
${pers.name} |
|
|
|
|
|
${childRow}${child.name} |
${child.actual.value} |
${child.target.value} |
|
|
|
${childRow}${child.name} |
${child.actual.value} |
${child.target.value} |
|
|
|
${TableEnd} |
|
|
|
|
could look like this when processed:
|
|
Result |
Target |
Status |
Trend |
|
Production |
|
|
|
|
|
Improve stock |
796.39 |
|
|
|
|
Reduce cost |
796.39 |
|
|
|
depending on the scorecard. In the example perspective 135 "Production" has two strategic objectives.
The tag ${child.actual.value} will return the first visible Actual value, and ${child.target.value} will return the first visible Target value.
Tree table
Like the Row table, the Tree table can be used for displaying a tree in a table. The ${treetable.pers} tag in the example below is used to indicate that this is a Tree table. The 'pers' part of the tag indicates that it should use the "pers" variable as the root of the tree. In this case it is set to the object with Id 135.
The Tree table has a special tag, ${level*}, that indicates that the row should be used for all objects of that depth in the tree. This table is a quick way of making the same style tables as the ones displayed on Corporater BMP web pages.
By default, Tree tables do not show objects that are invisible. See Global properties for more information.
Example:
#set(pers,${t.135})
|
${treetable.pers} ${pers.name} |
Result |
Target |
Status |
Trend |
|
${level1}${child.name} |
|
|
|
|
|
${level2}${child.name} |
${child.actual.value} |
${child.target.value} |
|
|
|
${TableEnd} |
|
|
|
|
could become:
|
|
Result |
Target |
Status |
Trend |
|
Improve stock |
|
|
|
|
|
Total stock |
796.39 |
|
|
|
|
Improve stock |
|
|
|
|
|
Total stock |
184.24 |
|
|
|
Limit table
Information about the Limit values is available in a table and can be used in all table operations in Reporter: Custom table, Expandable table, and charts. There is a Limit table entry in template listings for scorecards, perspectives, strategic objectives, KPIs, and all status objects.
Both of the syntaxes below may be used to set the current table to the limit table of KPI 103. They differ from ${Table.t.103} that will convert the KPI to a table instead.
Limit table
|
${Table.t.103.limittable}${expandable} |
|
and
Limit table
|
${Table.103.limittable}${expandable} |
|
could give the following result:
Limit table
|
Status |
From |
To |
|
|
10.00 |
30.00 |
|
|
30.00 |
60.00 |
|
|
60.00 |
100.00 |
