<div>
Maybe it works when you change it to:<br />
<br />
=&quot;Total NLR USD: &quot;&nbsp;&amp; Convert(Money, Fields!NLR_USD.Value)
</div>


Maybe it works when you change it to:

="Total NLR USD: " & Convert(Money, Fields!NLR_USD.Value)

<div>
Quickest way is to have:<br />
<br />
=&quot;Total NLR USD: $&quot; &amp;&nbsp;Fields!NLR_USD.Value<br />
<br />
This will work, though will only use $, so it depends if you need to have varying currency formats in your report.
</div>


Quickest way is to have:

="Total NLR USD: $" & Fields!NLR_USD.Value

This will work, though will only use $, so it depends if you need to have varying currency formats in your report.

<div>
simon, tried that but the number does not format with commas 1,000,000 prints as 1000000<br />
<br />
mjm, I get a build error on your suggestion:<br />
&nbsp;[BC30684] 'Convert' is a type and cannot be used as an expression.<br />
<br />
Thanks<br />

</div>


simon, tried that but the number does not format with commas 1,000,000 prints as 1000000

mjm, I get a build error on your suggestion:
 [BC30684] 'Convert' is a type and cannot be used as an expression.

Thanks


<div>
<div class="content wysiwyg-content">
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.<br />
<br />
Changing the properties of a cell that has an expression like:<br />
=&quot;Total NLR USD: &quot;&nbsp;&amp; Fields!NLR_USD.Value<br />
<br />
just leaves the number as, well, a number. How can I edit the expression to have the number in &quot;Value&quot; appear as currency.<br />
<br />
The result should print:<br />
<br />
Total NLR USD: $1,000,000.00 if value = 1000000<br />
<br />
Thanks
</div>
</div>


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

Thanks

change number format in a SQL Report Server expression string

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.