Multiple Rows and Concatenation in Tabular Reports

Depending on the level of granularity of the report, occurrences of multiple rows of data will either be output as separate rows, or concatenated into single cells.

Where columns have contents concatenated, the separator is a comma, and if any item in the list is blank or null, it is replaced with the text Unknown, otherwise blank or null values show as blank in the report.

Suppliers

Suppliers are output as separate columns for code and name. A column containing the concatenated code and name is available to add as an optional additional column, and may be used where a report is grouped by supplier.

Sites

Sites are output as separate columns for code and name. A column containing the concatenated code and name is available to add as an optional additional column, and may be used where a report is grouped by site.

Business Categories

Business Categories are output as separate columns for each level (the portal may have up to five levels configured). Multiples are concatenated, alpha sorted by the first level, so that the concatenated levels correspond. Reports contain separate columns for Lead and Other business categories, for where a portal is configured to use a separate single lead category and a list of other categories.

A column containing the full path is available to add as an optional additional column, and may be used where a report is to be grouped by business category.

Where Business Category appears as a default field in a core report, it is the full path. Where listed as an additional field that may be added, either the full path or individual levels can be used.