problem in report

shafeaa

hi
i design report that suppose to give me evry sealsperson and total amount for evry one of them. the problem that the report give my the same amount for all of them

Waldo

I think you'll have to be more clear about this: Amount is sum of which field in which tables?

shafeaa

thanks Waldo

Amount is sum of amount field in customer table

Waldo

I wouldn't know why you would need the amount on the customer table in combination with a salesperson ... . Helptext about this field:

Here you can enter an amount that is billed periodically (a subscription price, for example).

What you could do is the following:
Make a flowfield in table 13 (Salesperson/Purchaser) which calculates the sum of all amounts in the customer table, filtered on salesperson... .

use this flowfield in your report ... .

Is this what you were looking for?

Savatage

isn't their already a report "Sales Statistics By Salesperson"? That will give you the same info.

Waldo

As far as I know, I doesn't take in count the Amount on the Customer table.

But I think that modifying this report can be a step in the right direction...

randrews

Can you say number of report "Sales Statistics By Salesperson"?
I cant find it in my database (3.6).

Thanks in advance

Waldo

Report 114 - "Salesperson - Sales Statistics".

randrews

Thanks.
Object 114 in my base is:
Salesperson - Sales Statistics (version NAVW13.00)
That is why I did not find it