title: How do I show all group headers in Access 2007 reports?
body: <p>This is a question about Reports in Access 2007.
  I'm unsure whether the solution will involve any programming, but hopefully someone will be able to help me.</p>
  
  <p>I have a report which lists all records from a particular table (call it A), and groups them by their associated record in a related table (call it B). I use the 'group headers' to add the information from table-B into the report.</p>
  
  <p>The problem occurs when I filter the records from table-A that are shown in the report. If I filter out all table-A records that relate to a particular record (call it X) in table-B, the report no longer shows the record-X group header.</p>
  
  <p>As a possible workaround, I have tried to ensure that I have one empty record in table-A for each of the records in table-B. That way I can specify NOT to filter out these empty records. However, the outcome is ugly one-record-high blank spaces at the start of each group in the report.</p>
  
  <p>Does anyone know of an alternative solution?</p>
  
  <p><strong>EDIT:</strong></p>
  
  <p>For clarity, I should highlight what I hope to achieve. 
  For records in table-B that are not linked to any records in the filtered table-A, the group header (and footer) for these records will not appear in the report. I am trying to change this, so that the group header and footer appears immeiately after each other (since there are obviously no records to put in the group body).</p>