<div>
Hi,<br />
<br />
To do the same follow the below steps:<br />
<br />
1. Right click on the row<br />
2. Select Row Visibility<br />
3. Select Show or Hide based on an expression<br />
4. enter the expression as =IIF(Fields!ShowRow.Value = &quot;Yes&quot;, FALSE, TRUE)<br />
5. Preview the report<br />
<br />
It will definitely work<br />
<br />
Regards,<br />
Keyur Patel
</div>


Hi,

To do the same follow the below steps:

1. Right click on the row
2. Select Row Visibility
3. Select Show or Hide based on an expression
4. enter the expression as =IIF(Fields!ShowRow.Value = "Yes", FALSE, TRUE)
5. Preview the report

It will definitely work

Regards,
Keyur Patel

<div>
<div class="content wysiwyg-content">
So I tried to add a new field onto the SSRS report which is either a yes or no value.<br />
<br />
I want to hide the row in the SSRS report if the value is NO, and show if the value is YES.<br />
<br />
I added this to the row hidden expression and it won't do anything.<br />
<br />
Can someone help?<br />
iif(Field!ShowRow = &quot;Yes&quot;, true, false)
</div>
</div>


So I tried to add a new field onto the SSRS report which is either a yes or no value.

I want to hide the row in the SSRS report if the value is NO, and show if the value is YES.

I added this to the row hidden expression and it won't do anything.

Can someone help?
iif(Field!ShowRow = "Yes", true, false)

SSRS - how to hide a row?

A miscellany is defined as a "collection of various pieces of writing by different authors", but it has come to mean something "Of items gathered or considered together of various types or from different sources" or "a collection or group composed of members or elements of different kinds". The word "miscellaneous" comes from the Latin word "miscere", meaning "to mix." You might have heard the expression "a mixed bag," which applies when you don't quite know what you're going to get. More commonly, a miscellaneous group is made up of an odd group of things that don't fit anywhere else.

Miscellaneous

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.