<div>
or in this particular case you could just write:<br />
<br />
=Left(Fields!invoicetype.V<wbr />alue, 1)
</div>


or in this particular case you could just write:

=Left(Fields!invoicetype.Value, 1)

<div>
<div class="content wysiwyg-content">
Hello, &nbsp;<br />
I'm looking for expression in SSRS let me do it below:<br />
<br />
if (invoicetype) = &quot;Email Only&quot; then &quot;E&quot; or (invoicetype) = &quot;Harcopy Only&quot; then &quot;H&quot; or (invoicetype) = &quot;Both&quot; then &quot;B&quot;<br />
<br />
thanks<br />
<br />
henry
</div>
</div>


Hello,  
I'm looking for expression in SSRS let me do it below:

if (invoicetype) = "Email Only" then "E" or (invoicetype) = "Harcopy Only" then "H" or (invoicetype) = "Both" then "B"

thanks

henry

ssrs report

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.