<div>
Ah ok... thanks I didn't realize that's what it was saying. &nbsp;That fixed it.
</div>


Ah ok... thanks I didn't realize that's what it was saying.  That fixed it.

<div>
<div class="content wysiwyg-content">
Hi, I'm trying to add a dynamic font color to a percent field. &nbsp;If the percent is less than 10% I'd like the font color to be red and if its over 10, black. &nbsp;<br />
<br />
I put the following expression in the font color property:<br />
=iif(Sum(Fields!dailymargi<wbr />npct.Value<wbr />, &quot;ABookedDailyMarginPct&quot;) &lt;&nbsp;10,&quot;Red&quot;,&quot;Black&quot;)<br />
*I tried doing the value at 10 and .10 since its a decimal value before its formatted.<br />
<br />
However, when I try to preview the report I get the following error:<br />
[rsInvalidBooleanConstant]<wbr /> The Hidden expression for the textbox ‘dailymarginpct’ has the value “”, which is not a valid Boolean value.<br />
<br />
Anybody help me with this?
</div>
</div>


Hi, I'm trying to add a dynamic font color to a percent field.  If the percent is less than 10% I'd like the font color to be red and if its over 10, black.  

I put the following expression in the font color property:
=iif(Sum(Fields!dailymarginpct.Value, "ABookedDailyMarginPct") < 10,"Red","Black")
*I tried doing the value at 10 and .10 since its a decimal value before its formatted.

However, when I try to preview the report I get the following error:
[rsInvalidBooleanConstant] The Hidden expression for the textbox ‘dailymarginpct’ has the value “”, which is not a valid Boolean value.

Anybody help me with this?

Dynamic Font Color Problem ~ Business Intelligence Studio

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

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.

Microsoft SQL Server

A font is a particular size, weight and style of a typeface. Each font is a matched set of type, one piece (called a "sort") for each glyph, and a typeface consists of a range of fonts that share an overall design. With the advent of digital typography, font is frequently synonymous with typeface, although the two terms do not necessarily mean the same thing. In particular, the use of "vector" or "outline" fonts means that different sizes of a typeface can be dynamically generated from one design. Each style may still be in a separate "font file" -- for instance, the typeface "Futura" may include the fonts "Futura roman", "Futura italic", "Futura bold" and "Futura extended" —- but the term "font" might be applied either to one of these alone or to the whole typeface.