Hi all, I want to design a report like this:
customer no, doc no, amount 1, amount 2, opening date, finish date, total amount, amount 3
total amount is sum of amount 1 + amount 2. amount 1 and 2 is separated from documant type. amount 3 is coming from data source.
I defined customer, doc no, opening date, end date characteristics at row. amounts at column. but when I try to calculate total value according to customer number and documant number, it calculates zero. I restricted documant number as not equal empty (there are empty values since sum of customers don't have this info).
question 1: I want to sum value as customer based. how can I do?
question 2: are there any way to calculate sum value customer based? I tried to result rows tab at customer charactheristic -> always display but it doesn't work.
the resuls should like this:
customer no, doc no, amount 1, amount 2, opening date, finish date, total amount, amount 3
100 , 1, 2000$, 0$, 01.01.2008, 01.12.2009, 5000$, 10.000$
100 , 2, 0$, 3000$, 01.01.2009, 01.01.2010, 5000$, 10.000$
total:....
total amount is sum of 2000+3000 (it will repeate every row)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.