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 |
|
frant101
Starting Member
12 Posts |
 Posted - 2009-02-04 : 12:24:12
|
| I am using the COMPUTE FUNCTION as follows :SELECT .....COMPUTE SUM(soi.Cost_Amount)And this is giving me a result of SUM40978Which is great and returns the figure i want, my question is i dont want the header to be SUM i want it to be Total, i've tried thisCOMPUTE SUM(soi.Cost_Amount) As TotalBut this errors...is this not possible to do with COMPUTE...if it is could someone tell me how...please :) |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-04 : 12:32:53
|
| you could easily name this as Total in your front end application. Its just a formatting issue which is best dealt at front end. |
 |
|
|
|
|
|
Question about the COMPUTE function