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?
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.