Crystal Report Format

[yatesk]

Is it possible to get data on one line if a record has multiple line items? Example: A defendant receives a citation and he sets up a payment plan...when I generate a report this is how it looks:

Ticket Number Pay Amount Pay Date Pay Type
123123 25.00 11-25-06 CK
40.00 12-15-06 CA

How do I get this information on one line for this ticket number to look like this:

Ticket Number Pay Amount Pay Date Pay Type PayAmt...
123123 25.00 11-25-06 CK 40.00...

Is this possible?

 

[Madawc]

Do a group, based on Ticket Number.

Suppress the group header and detail lines.

Show the details in the group footer. Use running totals to accumulate the details and dates for CK and CA.

I'm assuming one of each, or maybe none. With several, the logic becomes more complex.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10