Hello magicfish,

Below are the steps you will want to follow to get the look you want in your report.
[i]Note: This is a pretty straight-forward process, the steps are a little long winded as I try to explain exactly what you need to look for. If you need further assistance, let us know.[/i]

     1) Start Sesame Designer and open your design file (DSR)
     2) Enter Report Design mode by selecting 'Reports > [Database_Name] > [Report_Name]'
     3) In Report Design mode, left click once on 'Group Header 1'. This will open the 'Report Section Properties' window.
     4) In the 'Report Section Properties' window, set 'Group Management' to "Add new group after this one". Click on 'Perform Selected Action'.
     5) In the 'Report Section Properties' window, left-click on the 'Ok' button.
     ** You will now have two group header rows and two group footer rows. 'Group Header 1' and 'Group Header 2' / 'Group Footer 1' and 'Group Footer 2'

     6) In Report Design mode, left click once on 'Group Header 2'. This will open the 'Report Section Properties' window.
     7) In the 'Report Section Properties' window, set 'Group Management' to "Add new group after this one". Click on 'Perform Selected Action'
     8) In the 'Report Section Properties' window, left-click on the 'Ok' button.
     ** You will now have three group header rows and three group footer rows. 'Group Header 1', 'Group Header 2' and 'Group Header 3' / 'Group Footer 1', 'Group Footer 2' and 'Group Footer 3' 

     9) Ensure that all column header text is in the 'Group Header 1' row. 'Group Footer 1' should contain your text and summary calculation elements.
     10) Leave the rows of 'Group Header 2' and 'Group Header 3' / 'Group Footer 2' and 'Group Footer 3' empty.
     11) Left-click once on 'Group Header 2' to open 'Report Section Properties'
     12) Set 'Break Element' to "Date Paid" and check the box labeled 'No Repeat'.
     13) Click 'OK'
     14) Left-click once on 'Group Header 3' to open 'Report Section Properties'
     15) Set 'Break Element' to "Customer" and check the box labeled 'No Repeat'.
     16) Click 'OK'      

     ** You should now have a report that will produce something like the following:

[code]
DATE PAID      CUSTOMER      AMOUNT PAID
03/01/2011      John Smith      $10.00
                       $20.00
                       $30.00
           Jane Sampleson      $60.00
03/02/2011      Fred Rubble      $30.00
           Wilma Flagstone      $40.00
---- etc ----
[/code]
     

Getting Your Footer Separator In Place

1) Click on 'Group Header 1'.
2) Set 'Group Management' to "Add new group after this one".
3) Move your static text elements that contain "====" into the new group footer that was created (should be Group Footer 2)


===

Adding Your Header Separator

Quote:


If you follow the steps above to add a non-breaking footer row for your "="s,  you should now be able to make use of Group Header 2 for your divider line.  Here's how:

1) Left-click into the row of 'Group Header 2'
2) Add a "Line" element to the row
3) Add enough Spacer elements to the row so that each row of your report design has the same number of elements
4) Count the number of elements in 'Group Header 2' (including the line element), we will need that number in a minute.
5) Left-click on the Line element in 'Group Header 2'
6) Click on the 'Position' tab of the Property Editor
7) Click in the width box and type "cN" (where N is the number of elements in 'Group Header 2')
    ** This tells Sesame to span N number of columns when it draws the line
8) Click on the arrow pointing to the right to apply the change.
9) Select all of the Spacer elements in the 'Group Header 2' row
    ** This can be done by Shift-Clicking each element.
10) Click on the 'Other' tab of the Property Editor
11) Set the option for 'Visible' to "No"
12) Save your changes

** You now have a simple divider that spans the width of your report.

Quote:


Double check the properties for your line element. You may have accidentally set it to be invisible.

Quote:

The User Guide covers all of the methods for building reports. We'll try to cover more "special case" techniques (spanning multiple columns, adding css, adding html, etc) in future knowledge-base articles.