Report Column

Description

Displays a single column in a Report Table.

This macro will usually contain at least one use of the Report Info macro, or another macro which displays information about the current item being reported on.


Parameters

NameRequiredAvailable InDefault ValueDescription

title

 (tick)


The title header to display

width

 (error)


The width of the column.

e.g.: "50px", "20em".

summaryType

 (error)


The type of summary to display at the end of this column.

May be one of:

  • sum - The sum total of all numbers in the column.
  • count - The number of non-blank values in the column.
  • average - The average of all numbers in the column.
  • stats - (Since 3.2.0) Gives access to all stats.

See summaryFormat for details.

Note that for all of the above parameters (except count), you MUST specify the summaryValue for the value that you wish to calculate the statistics for.

summaryValue

 (error)


The key chain value for the column summary, or plain text to display if the 'summaryType' is not set for this column.

e.g. "data:My Number", or "content:children > collection:size".

The summary value key can be completely unrelated to what is displaying in the column, if so desired.

summaryFormat

 (error)


The number format to use for the summary.

e.g.: "$#,##0.00".

(Since 3.2.0) If summaryType is stats, you can specify a %keychain% value here to output custom stats based on the Stats object.

e.g.: "Sum: %stats:sum%; Avg: %stats:value average%" 

colSpan

 (error)

1

(Since 3.2.0) The number of columns that this column should span across. 

injected

 (error)

false

(Since 2.0.0) If set to true, the body will have any '%prefix:keychain%' values injected with values from the current report item prior to being rendered. 

rowSpan

 (error)

1

(Since 3.2.0) The number of rows that this column should span down.

newRow

 (error)

false

(Since 3.2.0) If true, a new row will be started with this column. This is most useful in conjunction with colSpan and rowSpan.

class

 (error)


(Since 3.2.0) The CSS class(es) to add to this column.


Editor View


Notes

Examples

Keychain Injection

Output the title and excerpt of each child page.

{report-table}
{local-reporter:content:children}
{local-reporter}

{report-column:injected=true|title=Title}%content:title%{report-column}
{report-column:title=Body}{report-info:content:excerpt|render=wiki}{report-column}

{report-table}

Spanning Rows and Columns

Sometimes it's useful to have a column take up more space, or have two values one below the other. Using colSpan, rowSpan and newRow can help with more complex table layouts.

The example below will render the title on one row, the body on the next (spanning two rows itself) and the "Creator" and "Modifier" details on the right-hand side in two separate cells. Note the use of the class parameter on some columns to allow custom styling for those cells.

{report-table:displayTitles=false}
{local-reporter:content:children}
  {text-sort:content:title}
{local-reporter}

{report-column:title=Title|colspan=2|class=MyTitle}{report-info:title|link=true}{report-column}

{report-column:title=Content|rowspan=2|newRow=true}{report-info:body|render=wiki}{report-column}
{report-column:title=Creator|class=MyInfo}Created by {report-info:creator|link=true} @ {report-info:creation date|format=d MMM, yy h:mm a}{report-column}

{report-column:title=Modifier|newRow=true|class=MyInfo}Last post by {report-info:modifier|link=true} @ {report-info:modification date|format=d MMM, yy h:mm a}{report-column}

{report-empty}_No results are currently available._{report-empty}

{report-table}

Tutorial Examples

ServiceRocket
Products

Services

Workplace by Facebook
Training

Resources