Group by multiple fields in a report


Description

Group by multiple fields in a report. Let us say you have a time card report which is grouped by last name. However, if you have two employees with the same last name, then time cards of both the employees are grouped together. So you would like to group by  last name, first name to split the time cards into different groups.

Instructions

Group by feature in reports is designed to group by only one field. We can group by last name, first name in the specific order by using a function field.

Create a function field to concatenate last name and first name. Then group by the function field in the report.

First screenshot below displays the function field definition on 'sys_user' table and second screenshot below displays the report on 'time_card' table grouped by function field.

Link below to documentation which explains about function field.

https://docs.servicenow.com/bundle/quebec-platform-administration/page/build/platform-functions/concept/platform-support-functions.html