Please help me in my design
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?
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?
Comments
But it did, and i'm grateful