title: Crystal Reports XI - Suppress group header based on suppression status of sub-groups
body: <p>I have a rather simple problem that I haven't managed to workout for myself despite many hours of searching the web.</p>
  
  <p>I have a report containing timestamped data from a few thousand devices (loggers), to present the data in a sensible manner, I set up two groups in the report; Loggers and Timestamp so the data first grouped by logger id and then by timestamp which is working fine</p>
  
  <pre><code>Group 1 Logger 1
    Group 2 Timestamp 01/08/2012
      Data...
      Data...
      Data...
    Group 2 Timestamp 02/08/2012
      Data...
      Data...
  Group 1 Logger 2
    Group 2 Timestamp 01/08/2012
      Data...
      Data...
      Data...
  </code></pre>
  
  <p>Now the data (detail) fields are hidden from the user and I only want to display the header for group-2 if there are 4 or more records in each group-2. To achieve this I have used the following suppression formula on group-2</p>
  
  <pre><code>Count ({GMAC_spDg2Report;1.tTimeStamp}, {GMAC_spDg2Report;1.tTimeStamp}, "daily") &lt; 4
  </code></pre>
  
  <p>The trick is that there are certain level 1 groups where all group-2 headers are suppressed and where this is the case, I want to hide the group-1 header as well.
  Using the same suppression formula as group-2 in group 1 did not yield the desired result. I have also tried to use a running total (called {#Count Unsupressed Days}) in the group-1 footer with a distinct count and the formula below being reset on each group-1</p>
  
  <pre><code>Count ({GMAC_spDg2Report;1.strLogger}, {GMAC_spDg2Report;1.tTimeStamp}, "daily") &gt; 4
  </code></pre>
  
  <p>The running total works perfectly, returning a 1 in group-1 footer if the group has sub groups that are not suppressed and 0 if all group-2 headers are suppressed.</p>
  
  <p>So here is the CHALLENGE, I cannot seem to apply a suppression rule in the header of group-1 using the output from the running total.
  To demonstrate the problem I created a formula field containing only the output from the running total and placed this in the group-1 header. 
  The results are confusing to say the least... the formula field does not show the same value as the running total and hence the suppression rule is not working.</p>
  
  <p>I hope this makes some kind of sense... I feel like I have tried everything</p>