group in DBCross

pele

I have data in format

person1 | money | first name | last name
person1 | money | first name | last name
person1 | money | first name | last name
person2 | money | first name | last name
person2 | money | first name | last name
person3 | money | first name | last name
person3 | money | first name | last name
person3 | money | first name | last name
person3 | money | first name | last name

I want to get table in that format

person1 | SUM(money) | first name | last name
person2 | SUM(money) | first name | last name
person3 | SUM(money) | first name | last name

I've tried to use DBCross, but I get

person1 | SUM(money) | first name | last name
                       first name | last name
                       first name | last name
person2 | SUM(money) | first name | last name
                       first name | last name
person3 | SUM(money) | first name | last name
                       first name | last name
                       first name | last name
                       first name | last name

It is posible to group by repeated first name, last name and show only once.

P.S. SupperssRepeated doesn't help.

gpi

It seem better to use two-pass report with TfrxMasterData, TfrxGroupHeader and TfrxGroupFooter bands
Set height of TfrxGroupHeader and TfrxGroupFooter bands to true, calculate totals of group on the first pass and show it on the second pass