Skip to Content
0
Former Member
Oct 09, 2009 at 07:54 AM

Report Format

11 Views

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)