Combine Category Names on Same Record

[stanleytheyak]

I have a report that I'm writing which pulls Customer Contact tickets and their categories.  Each ticket can be placed into multiple categories.  Right now, what happens is that it returns multiple rows with the same Contact Ticket Number and notes for each Category, so it looks something like this:

Ticket    Category       Notes
1234     New Acct.       New acct. processing.
1234     Promo            New acct. processing.
1234     Phone App.    New acct. processing.

What I would like it to do is simply give me the ticket number and notes ONE time, with the three categories in the same cell.  Is this even possible?

[MFGF]

If this is a List report, you could group on Ticket and set the Group Span property of Notes to the Ticket groupling level. It means you would see the Ticket and Notes values just once.

Cheers!

MF.