title: SSRS 2008:How to hide a table row (Conditionally) based on category field
body: <p>I am new to Sql Server Reporting Services. I have created my following report.
  I want to remove/hide rows of Brand Total whenever it does not exist in Brand list. Like in following picture i want to remove/hide &quot;Ethnic Total&quot; whereas &quot;Ethnic&quot; Brand does not exist in &quot;Sample Store 1&quot;.
  Similary i want to reomve/hide rows of &quot;Outfitters Total&quot; and &quot;Junior Total&quot; from Section Two whereas &quot;Outfitters&quot; and &quot;Junior&quot; don't exist in &quot;Sample Store 2&quot;.<br />
  <img src="https://i.stack.imgur.com/2ZXmZ.png" alt="My Sample Report" /></p>
  <p>This is the structure of my report.
  <img src="https://i.stack.imgur.com/fursg.png" alt="Report Structure" /></p>
  <p>And following is the expression for Net Qty of a Single Brand total.</p>
  <p>=Sum(IIf(Fields!Brand.Value = &quot;Outfitters&quot;, Fields!Quantity.Value, Nothing))</p>
  <p>What should i do?
  What condition should i write in expression for Row Visibility?</p>
  <p>Thanks in Advance for help.</p>