<div>
<div class="content wysiwyg-content">
I have a multivalue parameter that asks for initials. &nbsp;They do not select from a list so they can leave it blank or add as many initials as they like. &nbsp;When they enter initials, this works fine: &nbsp;Join(Parameters!Initials.V<wbr />alue, &quot;, &quot;). &nbsp;It display the initials in the report header with a comma separator.<br />
<br />
If they don't enter any initials I want the expression in the report header to display &quot;ALL.&quot; &nbsp;This doesn't print anything:<br />
=IIF(Parameters!Initials.V<wbr />alue is Nothing, &quot;ALL&quot;, Join(Parameters!Initials.V<wbr />alue, &quot;, &quot;))<br />
I've also tried:<br />
IIF(Parameters!Initials.Va<wbr />lue=&quot;&quot;, &quot;ALL&quot;, Join(Parameters!Initials.V<wbr />alue, &quot;, &quot;))<br />
IIF(IsNothing(Parameters!I<wbr />nitials.Va<wbr />lue), &quot;ALL&quot;, Join(Parameters!Initials.V<wbr />alue, &quot;, &quot;))<br />
<br />
How do I need to write this?
</div>
</div>


I have a multivalue parameter that asks for initials.  They do not select from a list so they can leave it blank or add as many initials as they like.  When they enter initials, this works fine:  Join(Parameters!Initials.Value, ", ").  It display the initials in the report header with a comma separator.

If they don't enter any initials I want the expression in the report header to display "ALL."  This doesn't print anything:
=IIF(Parameters!Initials.Value is Nothing, "ALL", Join(Parameters!Initials.Value, ", "))
I've also tried:
IIF(Parameters!Initials.Value="", "ALL", Join(Parameters!Initials.Value, ", "))
IIF(IsNothing(Parameters!Initials.Value), "ALL", Join(Parameters!Initials.Value, ", "))

How do I need to write this?

If multivalue parameter is left blank then display &quot;All&quot; else display the values

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.

If multivalue parameter is left blank then display &quot;All&quot; else display the values

If multivalue parameter is left blank then display "All" else display the values