Friends, I am finishing a wonderful project, the catalog of the Baroque Music of Moxos (Eastern region of Bolivia). I´m acting as IT specialist, the real investigation is being done by experts in Music with admirable knowledge in this field.

FileMaker was used and everything went as expected, the database runs perfect the scripts do exactly what´s needed and the layouts for the experts to analyze the partitures (images containers) worked great. The idea is now to produce a Layout with the data for each composition along with these image containers. The Layout has a Header, a leading sub-sumary by signature, a body and a trailer sub-sumary again for the same field "signature", there are 9 container fields each the same size in the trailing sub-sumary part. Alas, the layout doesn´t work I presume because the combined length of the parts exceed the page size. The records are not printed as expected there is an offset at the top of the pages. I´m using all the options available to make the layout fit in one page but there is too much information and I really can´t reduce it any more. Any ideas I´m in real trouble I want to print the records using this layout as a PDF and send it to the printing press. Please if any body knows how to overcome this error/problem I and the team of specialist will be very grateful.

saludos,

Javier Miranda V.

What about reducing page margins? Also, you'll notice that things will shift a bit when printed to PDF.

I´ve tried to reduce the layout in every possible I´m way, using font in 9 points, and positioning the containers in two columns. The problem is the same using FileMaker Pro 11.

Any other ideas please!

Thank you for the suggestion.

Could you post a simple example file showing the problem?

The other question is why aren't those 9 container fields coming from 9 separate records - so each could be in a body part of its own (assuming you want them to be arranged vertically).

The Containers belong to the master file and are located in the trailer sub-sumary, the body contains the fields of the related records. In detail:

1.- Leading sub-sumary with general information of the musical composition (by signature). (fields defined in the master file).

2.- Body with information about the partitures comprising the musical composition. (fields defined in the slave file).

3.- Trailing sub-sumary with the 9 images (containers) for each composition. (fields defined in the master file).

Thank you friends

1. I don't see a file attached.

2. Your description doesn't say much. What is "the master file"? What does each record there represent? Why are there 9 containers for each composition? Does EVERY composition have EXACTLY 9 images? If not, each image should be a record in a related table (I believe this would also help your printing problem, but it is the correct structure regardless).

I'd suggest you get your data model in order before dealing with layout issues.

Thank you comment,I will try to convince the specialist to modify the layout in a way that the containers go in the body and not in a sub-summary, for that I´ll have to move the container fields to another table and make a relation. Thank you very much for your suggestion. If the change is approved the problem specific to this case will be solved. The problem with layouts exceeding a page, however still there.

Javier