<div>
<div class="content wysiwyg-content">
What is the syntex for a format expression to left justify &lt;fix&gt; the currency symbol in reporting services?<br />
<br />
In excel I would use: _($* #,##0.00_);_($* (#,##0.00);_($* &quot;-&quot;??_);_(@_)<br />
<br />
i've tried format(Fields!Amount.Value<wbr />,&quot;_($*#,##<wbr />0.00_)&quot;) &nbsp;and of course it didn't like that.<br />
<br />
Basically I want my currency detail to look like:<br />
$ &nbsp; &nbsp; 123.45<br />
$ 45678.34<br />
$ &nbsp; &nbsp; &nbsp;10.12<br />
<br />
In Crystal I would just mark it as fixed :(<br />
<br />
Thank you for any assistance<br />
<br />
<br />
<br />

</div>
</div>


What is the syntex for a format expression to left justify <fix> the currency symbol in reporting services?

In excel I would use: _($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)

i've tried format(Fields!Amount.Value,"_($*#,##0.00_)")  and of course it didn't like that.

Basically I want my currency detail to look like:
$     123.45
$ 45678.34
$      10.12

In Crystal I would just mark it as fixed :(

Thank you for any assistance





Reporting Services 2005 - Currency Format Style for fixed currency symbol

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.