Here's my scenario: I'm trying to design a report that uses two tables: Payments and Discounts. They are linked on a field, "ResID", and it's a left join from Payments to Discounts(so that every Payment shows, even if it there aren't Discounts for a ResID). I'm grouping on Payments.ResID. I want to design it so that for every group, it shows all the Payment records first, then every Discount record. So it'll be something like:
Res1
Res1.Payment1
Res1.Payment2
Res1.Discount1
Res1.Discount2
Res2
Res2.Payment1
etc.
I'm having so much trouble trying to design something like this...I've tried using multiple Details sections, but I keep getting information displayed more times than it needs to. Does anybody have any suggestions?
IP Logged
. And btw, I just ordered your book on Amazon...thanks for the quick and helpful reply!
But my current book on Amazon is only for Visual Studio .NET 2003. The "Encyclopedia Series" won't be out for another couple of months. If you are using Crystal Reports XI, you might want to cancel your order and wait for the new book in May.
