This is doable - there's a few different ways to do it. The route I would probably choose would be to have a subreport for each account showing the payments. Use linked parameters and then do the same thing you are below with the OnLastRecord.
Keep in mind I'm stuck at a car dealership at the moment waiting for an oil change and I haven't looked at Remedy in a week.... -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Stonequist Sent: Friday, December 28, 2007 12:19 PM To: [email protected] Subject: OT: Crystal Report - Last Record per Group Greetings List! I know this is more Crystal than Remedy, but I'm hoping someone here may be able to assist anyway. I'm trying to write a Crystal Report on a Joined Form which combines end-user Account Information (on the parent form) with end-user payment history records (from the child form). I need to display various details from both the account itself and information from the last payment only for each account. I tried inserting a group based on the Account Number, then suppressing Details if not "OnLastRecord", however, this only produced the very last record. When I tried various equations involving Previous, PreviousIsNull, Next, and NextIsNull, however, these produced 0 results or All results, instead of only the last results. HUGE thanks in Advance! Shawn Stonequist EMNS, Inc. Crystal Reports 11 ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
