title: Summary part not displaying in preview mode in Filemaker
body: <p>I have 2 tables in Filemaker Pro 11:</p>
  
  <ul>
  <li><p><code>"Donor"</code> table holds several fields for the donor including:</p>
  
  <pre><code>First Name
  Last Name
  Street Address
  City
  State
  </code></pre></li>
  <li><p>Individual donations are tracked in the related <code>"Donation Transactions"</code> table and this has the following fields:</p>
  
  <pre><code>Date
  Payment Type
  Amount
  Amount (Summary field: Running Total of the Amount field)
  </code></pre></li>
  </ul>
  
  <p>The two tables are joined by all the name and address fields. At this time, we do not have a unique number key column on the donor table hence have to use multiple fields to do this join.</p>
  
  <p>I need to be able to generate various summary reports for the amount. For example, I may need to summarize by Month (based on <code>Date</code>'s value in the <code>"Donor Transactions"</code> table), by <code>City</code> (field on the parent <code>"Donors table"</code>). I followed a tutorial to generate the summary by <code>"Last Name"</code> as a starting report.</p>
  
  <p>This is how the layout is defined:</p>
  
  <pre><code>[Header]       Last Name     Date       Payment Type         Amount          
  
  [Sub-summary]  _LastName_                                    _Amount Running Total_
  
  [Body]                       _Date_     _Payment Type_       _Amount_
  </code></pre>
  
  <p>.</p>
  
  <p>Note: <code>[Sub-summary]</code> section is sorted on the <code>Last Name</code>, but it's not being displayed in preview mode. I can see it in the browse mode where one record is displayed at a time and the running total gets updated as I move from one record to another.</p>
  
  <p>I would like to see the summaries in a table format with all the records sorted and displayed with the summary amount by name.</p>
  
  <p>Any ideas on what I may have done wrong? I appreciate any help.</p>