title: SSRS Hide group conditionally
body: <p>I have SSRS report with 3 groups in Tablix</p>
  
  <pre><code>-- Group A  
  ----Group B  
  ------Group C
  </code></pre>
  
  <p>If group C has 0 records then I do not want to show any of Group A, B and C.</p>
  
  <p>I tried to set the visibility property for Group A and Group B:</p>
  
  <pre><code>=IIF(Count(Fields!Field.Value)=0, true ,false)
  </code></pre>
  
  <p>But it is still showing the Groups A and B.</p>
  
  <p>I Tried <code>InScope</code> of group C and above condition, but this is still showing the Groups A and B when record count is 0.</p>
  
  <p>Also Group B is toggled by Group A and Group C is toggled by Group B. Not sure if that is an issue</p>
  
  <p>Data Table</p>
  
  <p>GroupA-------------------  GroupB -------------------  GroupC ----------------%Detail<br>
  School 1 --------------- Grade 4 -------------------  student1  -------------   50%<br>
  School 1 --------------- Grade 5  ------------------- student2  ----------------70%<br>
  School 1 --------------- Grade 4 -------------------  student3 ---------------- 60%<br>
  School 2 --------------- Grade 4 -------------------  student4  ----------------70%<br>
  School 2 --------------- Grade 5 -------------------  student5  ----------------60%  </p>
  
  <p>I have filter on GroupC to return the records has %Detail&lt;=50<br>
  In this case I in Group B i want to see only Grade 4 and in Group C student 1.<br>
  But if In group B I see Grade 4 (drill downs to student)and Grade5 (which does not drill but i don't want to see grade 5 at all in group B for this filter)  </p>
  
  <p>If I add this filter on GroupB I do not see anything not grade 4 and not grade 5</p>