<div>
Thank you for pointing me in the right direction with Instr. &nbsp;I'm new to report building and did not think to go to Instr first. &nbsp;I ended up going with the following syntax =IIF(InStr(Fields!CF_Str.V<wbr />alue,&quot;1&quot;)&gt;<wbr />0,&quot;Found&quot;,<wbr /> &quot;&nbsp;&quot;) &nbsp; , but the suggested syntax was helpful as well.
</div>


Thank you for pointing me in the right direction with Instr.  I'm new to report building and did not think to go to Instr first.  I ended up going with the following syntax =IIF(InStr(Fields!CF_Str.Value,"1")>0,"Found", " ")   , but the suggested syntax was helpful as well.

<div>
What I needed. &nbsp;Thanks!
</div>


<div>
<i>I ended up going with the following syntax =IIF(InStr(Fields!CF_Str.V<wbr />alue,&quot;1&quot;)&gt;<wbr />0,&quot;Found&quot;,<wbr /> &quot;&nbsp;&quot;) &nbsp; , but the suggested syntax was helpful as well.</i><br />
<br />
Well, as long as your numbers don't go higher than 9 it should work fine. &nbsp;Otherwise you'll run into the issue mentioned in my first post.
</div>


I ended up going with the following syntax =IIF(InStr(Fields!CF_Str.Value,"1")>0,"Found", " ")   , but the suggested syntax was helpful as well.

Well, as long as your numbers don't go higher than 9 it should work fine.  Otherwise you'll run into the issue mentioned in my first post.

<div>
<div class="content wysiwyg-content">
I have a field in my database that displays a list of numbers separated by a coma. &nbsp;Example &quot;0, 1, 2&quot; or &quot;1, 3, 5, 6&quot; . &nbsp;I want to create a calculated field that says if the original field contains a 1, then display the corresponding text description. &nbsp;The 1 could be in any location along the series. &nbsp;I've tried various combinations of Iif, Left, or Like, but these keep resulting in syntax errors. &nbsp;I'm looking for help to identify the proper function and related syntax. &nbsp;<br />
<br />
Any suggestions are greatly appreciated.<br />
<br />
Thank you,
</div>
</div>


I have a field in my database that displays a list of numbers separated by a coma.  Example "0, 1, 2" or "1, 3, 5, 6" .  I want to create a calculated field that says if the original field contains a 1, then display the corresponding text description.  The 1 could be in any location along the series.  I've tried various combinations of Iif, Left, or Like, but these keep resulting in syntax errors.  I'm looking for help to identify the proper function and related syntax.  

Any suggestions are greatly appreciated.

Thank you,

Report Builder 3.0 Calculated Field Expression Syntax for item similar to &quot;contains&quot;

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

DB Reporting Tools

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.

Report Builder 3.0 Calculated Field Expression Syntax for item similar to &quot;contains&quot;

Report Builder 3.0 Calculated Field Expression Syntax for item similar to "contains"