<div>
<div class="content wysiwyg-content">
I have the following expression<br />
<br />

<pre><code class="code-1 nolinks" id="code-10-29013173-1"><span>=Iif(Parameters!ShowCost.Value=&quot;Y&quot;,&quot;Cost: &quot; + CStr(Fields!std_cost.Value) + &quot; &quot;,&quot;&quot;) + Iif(Parameters!ShowPrice.Value=&quot;Y&quot;,&quot;Price: &quot; + CStr(Fields!std_price.Value),&quot;&quot;) + Iif(Fields!ETADate.Value=&quot;01/01/1900&quot;,&quot; NO ETA&quot;,&quot; ETA: &quot; + CStr(Fields!ETADate.Value))</span>
</code></pre>
<br />
I need to change this section so that if the ShowPrice = &quot;Margin&quot; then Price would be NPrice<br />

<pre><code class="code-1 nolinks" id="code-10-29013173-2"><span>Iif(Parameters!ShowPrice.Value=&quot;Y&quot;,&quot;Price: &quot; + CStr(Fields!std_price.Value),&quot;&quot;) + </span>
</code></pre>
</div>
</div>


I have the following expression

(CODE)

I need to change this section so that if the ShowPrice = "Margin" then Price would be NPrice
(CODE)

SSRS Expression syntax with Iif Else

syntax

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.