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 |
|
osirisa
Constraint Violating Yak Guru
289 Posts |
 Posted - 2008-03-10 : 16:31:42
|
| I created a Report on 2003 where we add the Column Receipts for SUM total and if the Total is Negative we put it in parenthesis ofr example (-378,890). The function below used to work in the previous version 2003. I migrated the report to 2005 and this funtion is not longer working. =IIF(SUM(Fields!Receipt.Value)> 0, (Fields!Receipt.Value), "(" + cstr(Fields!Receipt.Value) + ")")Thanks for the help, |
|
|
dineshasanka
Yak Posting Veteran
72 Posts |
Posted - 2008-03-12 : 15:41:49
|
| You don't have to do like this. YOu can use formating of the specific text box to do this---------------------http://dineshasanka.spaces.live.com/ |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-20 : 10:28:54
|
| use this for format specifier expression "###,##0;(###,##0)" |
|
|
|
|
|
|
I need help with Reporting Services 2005