Multiple Values per Report Field

[davidpanson]

Hi Everyone. Hopefully someone here can help me figure this out. I have a report that generates several thousand records with quite a few fields. There is one column that differs for every single record but frequently the records are identical except for that one field. So I would like to condense the field into multiple results, say user IDs for example. The field is not just a string so I can't append new information to it and as far as I can tell Service Now only displays one value per field. Is there a business rule or script I can write to just check to see the other categories are the same then display multiple IDs in one record?

Thanks

Here's an example of the kind of thing I'd like to do.

finished product:

group	number	description	user ID
help	4	Good stuff	jim654, rick432, bill234

Start here:

group	number	description	user ID
help	4	Good stuff	jim654
help	4	Good stuff	rick432
help	4	Good stuff	bill234

[Blaze2 · Accepted solution]

Unfortunately, this set up is not available yet in ServiceNow, due to the "List" configuration

You might want to do an enhancement request and if there are enough inquiries, SN will look into it.

I have seen a few questions in the community requesting the same thing, and still no positive result.

[davidpanson]

It's unfortunate that there's no standard way to do it but thank you for your reply.