change number format in a SQL Report Server expression string
Posted on 2004-11-16
Basically I get how to change the properties of a cell in a SQL Server Report but I can't figure out how to do it when my expression in a cell is not limited to a single field.
Changing the properties of a cell that has an expression like:
="Total NLR USD: " & Fields!NLR_USD.Value
just leaves the number as, well, a number. How can I edit the expression to have the number in "Value" appear as currency.
The result should print:
Total NLR USD: $1,000,000.00 if value = 1000000