<div>
That didn't work. <br />
=IIF(Parameters!HasAccess.<wbr />Value = &quot;ok&quot;, False, True)<br />
<br />
The Textbox should be visible and it is not. No matter what my value is in the pram
</div>


That didn't work.
=IIF(Parameters!HasAccess.Value = "ok", False, True)

The Textbox should be visible and it is not. No matter what my value is in the pram

<div>
Is the data type of the field char or boolean? It could be that the display is &quot;ok&quot; but if it's a boolean field, the actual value would probably be 1. If that's the case, try this:<br />
<br />
=IIF(Parameters!HasAccess.<wbr />Value = 1,False, True)<br />
<br />

</div>


Is the data type of the field char or boolean? It could be that the display is "ok" but if it's a boolean field, the actual value would probably be 1. If that's the case, try this:

=IIF(Parameters!HasAccess.Value = 1,False, True)



<div>
It is a char and not a boolean. The value is just text from a database. 
</div>


It is a char and not a boolean. The value is just text from a database.

<div>
Just to check: Is your IIF statement in the textbox's Properties &gt;&nbsp;Visibility tab &gt;&nbsp;Initial Visibility: Expression ...?<br />

</div>


Just to check: Is your IIF statement in the textbox's Properties > Visibility tab > Initial Visibility: Expression ...?


<div>
<div class="content wysiwyg-content">
I am trying to hide a textbox based on a report parameters value. Currently I have my code as =IIF(Parameters!HasAccess.<wbr />Value = &quot;ok1&quot;, True, False). The problem is the value for HasValue is actually &quot;ok&quot;, but the textbox is still showing up. What am I doing wrong?<br />

<pre><code id="code-8230064">=IIF(Parameters!HasAccess.Value = &quot;ok1&quot;, True, False)</code></pre>
</div>
</div>


I am trying to hide a textbox based on a report parameters value. Currently I have my code as =IIF(Parameters!HasAccess.Value = "ok1", True, False). The problem is the value for HasValue is actually "ok", but the textbox is still showing up. What am I doing wrong?

Hide a textbox based on a Parameters value

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.