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 |
|
chris_wood99
Yak Posting Veteran
70 Posts |
 Posted - 2006-01-16 : 05:11:48
|
| I'm creating some financial reports on Reporting Services on MSSQL 2000 to replace our current access reports. I am trying to recreate the layout and look of the reports as close to the old reports as possible.I need to remove the minus signs from the reports and replace them with Parentheses. The old formula in Access used to look like this.. =IIf(Sum([POSTED AMOUNT])<0,"(" & Format(Sum([POSTED AMOUNT])*-1,"#,###.00") & ")",Format(Sum([POSTED AMOUNT]),"#,###.00"))Anyone know how to recreate the same effect in Reporting Services? |
|
|
chris_wood99
Yak Posting Veteran
70 Posts |
Posted - 2006-01-16 : 06:08:56
|
| Hi,I have found the answer on msdn...this link gives the information required should anyone be interestedhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/acproFormatNumber.asp |
 |
|
|
|
|
|
Parentheses instead of minus symbol