Am using Crystal XI,
Have a group on a clientid, within that client am listing different sources of income for them, could have zero to multiple codes and also duplicate codes.
Want to display based on one code, in this instance "c" but also only display if this is the only amount. I am able to display only those records that include "c" but want to display those records where "c" is the only income code for that person.
Example data would be
CLient Total Income
x 1000
Client Detail
Name Income Code Amount
x c 500.00
x c 500.00
Client Total Income
y 1000
Client Detail
Name Income Code Amount
y a 250
y c 500
y g 250
In the above examples only client x should be displayed, as i have it now it will show client x but it also shows the one line for client Y which i do not want. Am trying to also base it on the sum of amount = to total amount but can't get it to work. Any ideas or suggestions are appreciated.
Have a group on a clientid, within that client am listing different sources of income for them, could have zero to multiple codes and also duplicate codes.
Want to display based on one code, in this instance "c" but also only display if this is the only amount. I am able to display only those records that include "c" but want to display those records where "c" is the only income code for that person.
Example data would be
CLient Total Income
x 1000
Client Detail
Name Income Code Amount
x c 500.00
x c 500.00
Client Total Income
y 1000
Client Detail
Name Income Code Amount
y a 250
y c 500
y g 250
In the above examples only client x should be displayed, as i have it now it will show client x but it also shows the one line for client Y which i do not want. Am trying to also base it on the sum of amount = to total amount but can't get it to work. Any ideas or suggestions are appreciated.