I am creating a membership directory from my FM membership database. I would like to get the names of the states to repeat at the top of the next column or page when the number of records for a particular state doesn't fit in only one column. 

 

I have two leading "sub-summaries when sorted on",  the first for Country and the second for State. 

 

I will be printing in two columns per page.

 

Thanks for any help in advance.

Hi Rennie,

 

In Preview mode you should be able to see how your layout will look when printed.  

 

I think you could get the States names to appear before your data and at the top of a new page, with the combination of sub-summary part sorted by State, and by placing the State field in the header part of your layout.  (View your content as a list).  -- In Layout mode choose Layout Setup… Printing and select Print in [2] columns.

 

Another way to get two columns of data on a layout is by displaying it in two side-by-side portals on a layout of a related table.  For the second portal you specify it to start one row after the last row of the first portal.  It will be a challenge, though, to get portals to display sub summary data, and to print across multiple pages. 

 

- Edit:  I corrected my comment about list mode not printing in two columns.  Pardon my ignorance. - 

Edited November 27, 201312 yr by Matthew F

Putting State in the header will work with two columns. Good idea.

 

You might then use some conditional formatting to hide the header field when it's not needed, something like:

 

State <> GetNthRecord( State ; Get ( RecordNumber ) - 1 )