FillColourCondition.rdl

2018-02-18_22-05-52.jpg

<div>
That worked....thanks for the help!
</div>


<div>
<div class="content wysiwyg-content">
I need to highlight (fill) a field based on when the numeric value is greater than 7.00. <br />
<br />
I tried the following expression in the text box properties &gt;&nbsp;&quot;Fill&quot; <br />
<br />
=IIF(SUM(Fields!Dispatched<wbr />_to_at_Sce<wbr />ne.Value, &quot;DataSet1&quot;) &gt;7.00, &quot;yellow&quot;, &quot;no color&quot;)<br />
<br />
However, it highlights the entire column regardless of the value...<br />
<br />
Thanks in advance.
</div>
</div>


I need to highlight (fill) a field based on when the numeric value is greater than 7.00. 

I tried the following expression in the text box properties > "Fill" 

=IIF(SUM(Fields!Dispatched_to_at_Scene.Value, "DataSet1") >7.00, "yellow", "no color")

However, it highlights the entire column regardless of the value...

Thanks in advance.

Highlighting (FILL) on values using an Expression in SSRS

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.