RAVE - suppress duplicated values


2005-05-09 06:12:23 PM
delphi107
Hi !
Im 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