Hi if i run the below sql statement in Query analyzer select 2967.0000 +1.1480 +217.7942 it's giving ------------ 3185.9422 the same field i am formating to currency in Reporting services report, there i am getting $3184.79 i am losing nearly 2 dollers. if any one faced same problem before please kindly point me the solutions. Thanks Mathi Thanks & Regards Mathivanan K Great work may have to pass through these stages - ridicule, opposition, and then acceptance. Each man who thinks ahead of his time will probably be greatly misunderstood.- vivekananda
It seems the output from Query analyzer is correct as far as arithmetic is concerned. --- Sunil "Its nice to be Important, But its more important to be Nice"
Seems the second value : 1.1480 is being missed out in Reporting services report as this is exactly the difference if you take precision upto two digits --- Sunil "Its nice to be Important, But its more important to be Nice"
At the reporting services report, drag in the field to a textbox then right click on the textbox, choose Expression Edit the expression: ="$" & Format(sum(Fields!YourFieldName.value, YourDataSetName),"##,###,##0.00") and you should be able to get the correct result..
