Please help me in my design

PNassetti

Greetings

I want an report that goes something like this:

Client1 name and id band

- Client1 tax data
- ...
- Client1 tax data

-- Client1 tax sum

(some data)

ClientN name and id band

- ClientN tax data
- ...
- ClientN tax data

-- ClientN tax sum

Sum of all sums

What im getting is close but is ugly and incorrect.
The name, id and tax data are there, i also got the total sum right (i mean, the idea is right), but the local client sum is driving me mad because the client totals are getting EVERYONE'S total, ending in some weird stuff like:

Client1 name and id band --data1(with the dataset)

- Client1 tax data
- ...

---

data2(bound to data1)
- Client1 tax data

-- Client1 tax sum

---

data3(bound to data2)

Client2 name and id band

- Client2 tax data
- ...
- Client2 tax data

-- Client1 + Client2 tax sum

...

ClientN name and id band

- ClientN tax data
- ...
- ClientN tax data

-- ClientN + Client(N-1) + ... + Client2 + Client1 tax sum

Sum of all sums (ending in a huge number)

I dont know how to properly condition the totals, can someone help me?

ipong

just ignore 'total per page', you only need group header/footer, report summary, and totals

PNassetti

ipong wrote: »

just ignore 'total per page', you only need group header/footer, report summary, and totals

It was really strange to see it work
But it did, and i'm grateful