I have a database of 550 names consisting of contact information (name, address, telephone, etc...) I have set up a portal to group records based on whether or not they are the same members of a family. Some families only consist of one member, but many have anywhere from 2 to 8 members. Ultimately, I want to print the entire database on a layout that groups the families together. So far, I'm wasting a lot of space because I have the portal set up to accomodate the largest family. Is there a way to make the portal automatically adjust its number of rows depending on the data that it needs to show?

M.

You'll want to use subsummarys.

That *basic* idea:

Make a new part in your layout above the body that is a subsummary.

Set it to sort my family

Run a sort by family

Go into Preview mode.

You'll then have a list with records grouped by family.

Thanks for your quick reply. However, there is something I did not mention that puts a twist on the whole thing. In addition to simply printing out the entire database grouped by family, I want to print out the entire database grouped by geographic area and then by family. I already have a subsummary report that will list the individuals according to their geographic area. What I want now is to print out the database in groups of families that are divided according to their geographic area.

Thanks,

M.

I'm fairly sure you can just add another subsummary part and the do the sort by location then family and it should turn out.