Board index » delphi » RAVE - suppress duplicated values
Robert Meyer
 Delphi Developer |
RAVE - suppress duplicated values2005-05-09 06:12:23 PM delphi107 Hi ! I´m using Delphi 2005E and Rave. How can I suppress duplicated values within a Detail-Band. My data are ProjectID ProjectName Projectvalue LoanID LoanAmount 0001 Project 1 100000 001 70000 0001 Project 1 100000 002 30000 0002 Project 2 200000 003 120000 0002 Project 2 200000 004 60000 0002 Project 2 200000 005 20000 0003 Project 3 50000 006 50000 and should be displayed as ProjectID ProjectName ProjectValue LoanID LoanAmount 0001 Project 1 100000 001 70000 002 30000 0002 Project 2 200000 003 120000 004 60000 005 20000 0003 Project 3 50000 006 50000 Total 3 records 350000 350000 So, for each record, that has the same ProjectID as the prior record, only LoanID and LoanAmount should be displayed. Also the total should only summarize the displayed ProjectValues. Thanks in advance ! Robert |