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 |
|
fbcarl
Starting Member
3 Posts |
 Posted - 2008-05-17 : 21:40:14
|
| here is table i want to view on crystal report 8.5FIELD 1 : FIELD: 2CASH IN BANK 1000.00LOANS PAYABLE 1000.00CASH IN BANK 500.00LOANS RECEIVABLE 500.00........ETC ...ETCi want to look it like this on the reportCASH IN BANK 1500LOANS PAYABLE 1000LOANS RECEIVABLE 500.... AND SO ON...........i select "Select Distinct" on the database menu and i get the distinct name of field 1 but when i make a sql field expression for the sum of the like for ex cash in bank i got error that the field 1 is not part of an aggregate expression is there any other way to do it. thanks.... |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-05-19 : 01:46:48
|
| Group by field 1. There is no need to make it distinct as when you are grouping, it will combine all rows with the same grouped by value. |
 |
|
|
|
|
|
help sql expression field