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 |
|
Van
Constraint Violating Yak Guru
462 Posts |
 Posted - 2008-12-10 : 12:23:32
|
| I have a field on a report (SSRS) and when I format it to currency (inside of SSRS) it puts an R infront of the value instead of a $. None of the other currency fields on the report do this. They format correctly with a $. The field that is putting an R in front is a Total field that is just adding a few fields together and the fields it's adding together are formated as currency and are all formatting correctly with a $. Any ideas?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-10 : 12:28:34
|
| how are you format it? by selecting option inside the format tab or using custom format expression? |
 |
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2008-12-10 : 12:28:45
|
| Just found it (had been searching for a while even before posting here). It was a language setting on that textbox on the report. Have no idea how it got changed or it may have already been like that when I inherited the report. |
|
|
|
|
|
|
Format to currency puts an R in front