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.

 All Forums
 Development Tools
 Reporting Services Development
 Error in calculating sum in Reporting services

Author  Topic 

shagarwal
Starting Member

5 Posts

Posted - 2006-02-26 : 03:22:28
Im calculating sum in Reporting service.

I have written a simple formula


SUM(Fields!PrincipalAmount.VAlue)

Still it returns me an error.

RS acts some what wierd coz sometimes this error gets resolved if
i used this formula instead


SUM(Fields!PrincipalAmount.VAlue -0 ) .Just by typing minus zero sometimes the result comes fine. Has anyone any idea how to resolve this ???

TIA
   

- Advertisement -