# Meetings: All Invitees in one field? **URL:** \ **Category:** KReporter\ **Created:** [November 23, 2016, 12:15pm UTC](https://community.spicecrm.io/t/meetings-all-invitees-in-one-field/31 "2016-11-23T12:15:16Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![MayerElyashiv](https://avatars.discourse-cdn.com/v4/letter/m/a3d4f5/32.png) [@MayerElyashiv](https://community.spicecrm.io/u/MayerElyashiv)\ **Post date:** [November 23, 2016, 12:15pm UTC](https://community.spicecrm.io/t/meetings-all-invitees-in-one-field/31/1 "2016-11-23T12:15:16Z")
Hi, is it possible to create a Report for Meetings, where you see the list of all invitees in a field? I’m thinking about one field for Users, one for Leads, one for Contacts… ---
**Author:** ![spicecrm](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.spicecrm.io/spicecrm/32/7_2.png) [@spicecrm](https://community.spicecrm.io/u/spicecrm)\ **Post date:** [November 23, 2016, 12:59pm UTC](https://community.spicecrm.io/t/meetings-all-invitees-in-one-field/31/2 "2016-11-23T12:59:03Z")
you can use the group concat function in KReporter. Like in this example ![](https://canada1.discourse-cdn.com/flex030/uploads/spicecrm/original/1X/7ec5b296c0a07383e8c575be86f46a32a932d9fd.jpg) Create a report on meetings, drag over the contact name (I also added a custom function to concatenate first and last name) and make a group concat. Group by the meeting ID (a field that afterwards is hidden from the display. The result is as follows: ![](https://canada1.discourse-cdn.com/flex030/uploads/spicecrm/original/1X/4b1d79b583fed2acc52633885a2635514fcc98b4.jpg) As you can see you get a list of the meeting and all contacts linked are displayed concatenated in one field. You can then of course do the same for users leads, etc. And if you set the contacts field to optional in the reporter you get also meetings where no contact is linked.