Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
davecarrera
Starting Member
4 Posts |
 Posted - 2006-04-12 : 06:25:00
|
| Hi All,I have my first report working and have managed to make the dropdown list function give me back data relevant to the select option on that list, all well there.I have also managed to make BETWEEN dates work as far as the get data part is concerned.I have two tables 1) customers 2) tradesHow do i show the TOTAL or SUM of trades for a customer instead of each individual item for a customer, oh and how do you put a grand total at the end of the report.So the out put would look like this...Customer Trades0001 123.450002 2345.970003 32.45And so on.Any help with this is gratefully recievedKind RegardsDave C |
|
|
|
|
|
First report need some help