Can I get a leading sub summary to repeat on following pages?

[Rennie]

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.

[Matthew F]

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, 2013 by Matthew F

[Fitch]

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 )