<div>
Try that..<br />

<pre><code class="code-1 nolinks" id="code-8225780"><span>IIF(Fields!promise_date.Value &lt; Now(), &quot;PINK&quot;, IIF(Fields!promise_date.Value Is Nothing,&quot;RED&quot;, &quot;WHITE&quot;))</span>
</code></pre>
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
I'm working on an SSRS report and i'm trying to conditionally format a particular field on the report, but I have to have more than on IIF statement in the expression. I'm fairly still new to writing these expressions and have not been able to get it right yet.<br />
<br />
On the properties box for this field on the background color property I have this expression.<br />
<br />
=IIF(IsNothing(Fields!prom<wbr />ise_date.V<wbr />alue),&quot;Red<wbr />&quot;,&quot;White&quot;)<wbr /><br />
<br />
I need to add another condtional check which is the Crystal Report Syntax below:<br />
<br />
IF {poitem.promise_date} &lt;&nbsp;CURRENTDATE then color (255,204,255) ELSE <br />
IF ISNULL({poitem.promise_dat<wbr />e}) THEN COLOR(0,255,0) ELSE NOCOLOR<br />
<br />
So far I keep getting errors. Lookin for some help.<br />
<br />

</div>
</div>


Hi,
I'm working on an SSRS report and i'm trying to conditionally format a particular field on the report, but I have to have more than on IIF statement in the expression. I'm fairly still new to writing these expressions and have not been able to get it right yet.

On the properties box for this field on the background color property I have this expression.

=IIF(IsNothing(Fields!promise_date.Value),"Red","White")

I need to add another condtional check which is the Crystal Report Syntax below:

IF {poitem.promise_date} < CURRENTDATE then color (255,204,255) ELSE 
IF ISNULL({poitem.promise_date}) THEN COLOR(0,255,0) ELSE NOCOLOR

So far I keep getting errors. Lookin for some help.



Multiple IIF statements SSRS expression

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.

SSRS

A regular expression ("regex") is a sequence of characters that define a search pattern, mainly for use in pattern matching with strings, or string matching, i.e. "find and replace"-like operations. Regular expression processors are found in several search engines, search and replace dialogs of several word processors and text editors, and in the command lines of text processing utilities, such as sed and AWK. Many programming languages provide regular expression capabilities, some built-in, for example Perl, JavaScript, Ruby, AWK, and Tcl, and others via a standard library, for example .NET languages, Java, Python and C++ (since C++11). Most other languages offer regular expressions via a library.

Regular Expressions

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.