Multiple Values on the same line

[MiagiSan]

Hello,

I did not find anything in the FAQ about this so here goes.

I am using CR 10 with an SQL database and I have created a report that shows Support tickets, Agent name, Company Name, etc...

The report looks like this:

Ticket# Agent Name Company Name
12345 John Company1
67890 Bill Company2


There is an option in our ticketing database that will allow you to relate (Child) tickets to (Parent)tickets. I want to show all the related Child ticket numbers on the same line like so:

Ticket# Agent Name Company Name Related Tickets
12345 John Company1 11111
22222
33333
67890 Bill Company2 55555
66666


When I add the the related ticket field to this report, {relationship.related_case} It looks like this:

Ticket# Agent Name Company Name Related Tickets
12345 John Company1 11111
12345 John Company1 22222
12345 John Company1 33333


Grouping by Ticket # does not do the trick. Is this possible in Crystal?

Thanks very much; I hope I have enough information here.

R

 

[mocgp]

Create a Group on Ticket # (you may already have this in the report) and place the Ticket #, Agent Name, and Company Name fields in the group header section. The Related Tickets field remains in the Detail section. Now go the the Section Expert and, for Group 1, check the "Underlay following sections" box. This will "roll up" the common information onto one line and the details will show as a list in the proper format.

 

[MiagiSan]

Thank you very much!

 

[mintman]

Did that work?, I did this before but I used While printing records. Good one Mocgp .

 

[MiagiSan]

Yes it did however the details section with the related tickets are showing up slightly below the rest of the ticket data so I got creative with some of the formatting. (Colors, etc..)

Thanks again Mocgp!

 

[lbass]

You could have placed the fields in the detail section and then formatted the first three fields to "suppress if duplicated" (format field->common tab->suppress if duplcated).

-LB