<div>
LOL! &nbsp;I didn't think about the placement of the parentheses!<br />
<br />
You're right, as usual!<br />
<br />
Thank you, Nicobo, for getting me out of yet another debacle!!!<br />
<br />
John
</div>


LOL!  I didn't think about the placement of the parentheses!

You're right, as usual!

Thank you, Nicobo, for getting me out of yet another debacle!!!

John

<div>
Nicobo is an asset to Experts Exchange!
</div>


<div>
<div class="content wysiwyg-content">
Hello:<br />
<br />
I have a field containing a formula. &nbsp;I know that SQL Reporting Services offers conditional formatting, where you can have a field display as Red when the field is less than 0. &nbsp;But, how do you do that when the field is a formula?<br />
<br />
Here is the formula:<br />
<br />
=Sum(iif(Fields!SOPTYPE.Va<wbr />lue=4, <br />
-Fields!XTNDPRCE.Value, <br />
Fields!XTNDPRCE.Value))<br />
<br />
This formual is a sum based ono a grouping.<br />
<br />
I went into the Placeholder properties and then in the Font section and clicked the function button. &nbsp;Then, I entered the following:<br />
<br />
=iif(Sum(iif(Fields!SOPTYP<wbr />E.Value=4,<wbr /> <br />
-Fields!XTNDPRCE.Value, <br />
Fields!XTNDPRCE.Value))) &lt;&nbsp;0, Red, Black<br />
<br />
But,I got an error upon running the report with this.<br />
<br />
How do you do this conditional formatting when there is a formula. &nbsp;I know that this would work with a regular field.<br />
<br />
Thanks!<br />
<br />
Apitech
</div>
</div>


Hello:

I have a field containing a formula.  I know that SQL Reporting Services offers conditional formatting, where you can have a field display as Red when the field is less than 0.  But, how do you do that when the field is a formula?

Here is the formula:

=Sum(iif(Fields!SOPTYPE.Value=4, 
-Fields!XTNDPRCE.Value, 
Fields!XTNDPRCE.Value))

This formual is a sum based ono a grouping.

I went into the Placeholder properties and then in the Font section and clicked the function button.  Then, I entered the following:

=iif(Sum(iif(Fields!SOPTYPE.Value=4, 
-Fields!XTNDPRCE.Value, 
Fields!XTNDPRCE.Value))) < 0, Red, Black

But,I got an error upon running the report with this.

How do you do this conditional formatting when there is a formula.  I know that this would work with a regular field.

Thanks!

Apitech

Conditional Formatting on a Formula in SQL Reporting Services 2008

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.