Crystal Report Format 1

[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? I am using Crystal 8.5 version.

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

Is this possible?

 

[SQLBill]

I suggest you post this in one of the Crystal Report forums?

-SQLBill

Posting advice: FAQ481-4875

 

[philhege]

And besides, what if the miscreant sends in one-cent payments? You're gonna run out of real estate real quick.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'll have the roast duck with the mango salsa.

 

[yatesk]

Thank you SQLBill