pierre
01 Mar 2010, 04:56 PM
Hi,
I have a client that has a sales force. The salesmen go out and sell, then everyday they fill out a sales report.
I can build a form that captures the data, and writes it to a db table. My question is what is the best way to collate that data and present it in the form of a report (that does all of the math)
For example, salesman1 sells a bunch of productA, and salesman2 sells a bunch of productA, you want to be able to access a report that adds up the sales of both salesman1 and 2 and gives you a tally all sales of productA (for a given period of time).
This is the most basic example. Now add in the complexity of there being several forms to capture several types of data, that all needs to get used to collate several reports using the data from multiple forms.
I have a client that has a sales force. The salesmen go out and sell, then everyday they fill out a sales report.
I can build a form that captures the data, and writes it to a db table. My question is what is the best way to collate that data and present it in the form of a report (that does all of the math)
For example, salesman1 sells a bunch of productA, and salesman2 sells a bunch of productA, you want to be able to access a report that adds up the sales of both salesman1 and 2 and gives you a tally all sales of productA (for a given period of time).
This is the most basic example. Now add in the complexity of there being several forms to capture several types of data, that all needs to get used to collate several reports using the data from multiple forms.