<div>
you may try ABS function, like:<br />
<br />

<pre><code id="code-20-40949433-1">=Format(ABS(Fields!fieldvalue.Value), 0) </code></pre>
</div>


you may try ABS function, like:



=Format(ABS(Fields!fieldvalue.Value), 0) 

<div>
I tried that and it didn't show the negative as negative at all.<br />
<br />
I need it to display like this (233.23)
</div>


I tried that and it didn't show the negative as negative at all.

I need it to display like this (233.23)

<div>
ok, what about this?<br />

<pre><code id="code-20-40949987-1">=IIF( Fields!fieldvalue.Value &lt; 0 , &quot;(&quot; &amp; Format(ABS(Fields!fieldvalue.Value), 0)  &amp; &quot;)&quot; , Format(Fields!fieldvalue.Value, 0)  )</code></pre>
</div>


ok, what about this?


=IIF( Fields!fieldvalue.Value < 0 , "(" & Format(ABS(Fields!fieldvalue.Value), 0)  & ")" , Format(Fields!fieldvalue.Value, 0)  )

<div>
try <br />
<br />
<br />
Format(Fields!fieldvalue.V<wbr />alue, &quot;#,#0.00&quot;;(#,#0.00))
</div>


try


Format(Fields!fieldvalue.Value, "#,#0.00";(#,#0.00))

<div>
That gives me an error<br />
<a href="https://filedb.experts-exchange.com/incoming/2015/08_w35/932045/Capture.JPG" target="_blank" title="] (17 KB)"><img alt="]" class="file-block lazyload" style="max-width: 652px;" data-src="https://filedb.experts-exchange.com/incoming/2015/08_w35/932045/Capture.JPG" /></a><br />
&quot;character is not valid&quot;
</div>


That gives me an error
]https://filedb.experts-exchange.com/incoming/2015/08_w35/932045/Capture.JPG
"character is not valid"

Capture.JPG

<div>
<div class="content wysiwyg-content">
This code<br />
<br />
=Format(Fields!fieldvalue.<wbr />Value, 0) <br />
<br />
shows negative formatted like -123.23 i want it like (123.23)
</div>
</div>


This code

=Format(Fields!fieldvalue.Value, 0) 

shows negative formatted like -123.23 i want it like (123.23)

=Format(Fields!fieldvalue.Value, 0) - shows negative like -123.23 i want it like (123.23)

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.