Can you provide a sample file so that we could see what you are working with layout wise? =)
how can you dynamocally show which record has less data
again printing only deals with the data that present on the layout.
so i think it is not possible to show 2 record values in one layout .
You can set the body part to fill one page, as I assume you have now, with the various fields in that body part extended down to fill it to the bottom. If you set in 'Sliding and Printing' all of those fields to slide upwards when printing (and the enlosed part also) then your print will shrink the found records to fit only the data that is in them, and it will print more records per page if they have little data.
I am attaching a PDF file which consists of one record. I use the sliding mechanism to move everything up as much as possible. This example shows that there is enough room for another record if it is no bigger than the one already there. Let me know if the attachement doesn't come through.
When using the sliding option, also select "resize enclosing part" and specify these same two options for any other layout objects (even layout text or lines) to also slide up and shrink unless they are located at the very top of the body.
Let's also check the obvious:
- you have found more than 1 record
- you have not set the print options to print current record only.
No pdf available.
I couldn't post a PDF image but attached a screenshot to my original posting. That is one record and the problem is not how to find more records but how to somehow show them or attach them together in one body. I use sliding and enclosing on all the parts but it is sometimes tricky. For instance, I discovered that text fields react differently than merge variables in that they have different effects on the items below them. I had to replace a couple of text fields with merge variables. Is there a good tutorial on this particular subject?
For sliding to work, you need to keep these details in mind:
- It's not visible in Browse or Find Modes
- If you set a field to slide up, all objects, including graphic objects such as a horizontal line that are next to or below the sliding field must be given the same options to slide and resize.
- If you do not select the Resize Enclosing Part option, the fields will slide up, but the empty space on your report will remain, below the objects that have slid up.
- Objects not in the layout body (as far as I know), do not slide/resize
- Fields inside of portals cannot be set to slide, but the portal itself can be set to slide to adjust for varying numbers of portal rows.
- If you have fields that may need to span a page break, make sure that you've downloaded the 11.0v3 updater as it claims to fix an issue where the text can be split over the break.
Not related to helping you at all but I just had to chime in to say - Awesome layout on your report page, looks very crisp and clean. Very professional looking.
thanks for the compliment.
ON further reflection, my question should have been: how can I print more than 1 Layout per page? My layout (shown above) is built from records from 3 tables and a 2nd layout would be similar but be built from a different set of records.
Can't be done. It's strictly one layout per customer with exactly one exception to that. If you use a script to generate a PDF of the layout, there's an option that allows you to append a PDF to an existing PDF file. Thus, you could save a PDF of layout #1, switch to layout #2 and save a PDF--appending it to the end of the PDF from layout #1.
Before you try something that cumbersome, feel free to describe your two layouts and the records you want to display in each. There may be a way to combine all that data on a single layout.
I looked for a way some time ago to append one pdf file to another because that would solve my whole problem and (I suspect) would be the easiest to implement. But I couldn't find a way to make that happen. I tried just now, and couldn't find an "append" option anywhere, either in the script steps I used or doing it manually.
I thought about creating two layouts in one layout. The outcome would be fine but doing so would require that I make a duplicate layout. Doing that would be OK but I would have to relabel about 60 merge variables on the second layout. Then I would have to duplicate the scripts which loaded the data in the 1st layout and then change the duplicate script to work only on the 2nd layout and change all the merge variable references as well. The set of scripts for each layout consists of about 500 lines of code. Finally, this option would not provide the capability to append 3 or 4 PDF files together.
So the "append" option is the only one I can think if I can just get that to work.
In FM11 (at least) the Save Records as pdf script step has two options in the bottom left - the first is 'Append to existing file'.
Thanks Sorbsbuster, Filemaker 10 and 11 have that feature. It's a script step--not something you can do from the File menu.
Howard, I'm not sure you are understanding my question.
You specify two layouts: On layout #1, what records are you listing in your report?
On layout #2, what records are your listing on your report?
Are they records from the same table? Different but related tables?
What key limitation are you encountering that makes two different layouts necessary?
I can't see your database from here, so what I am proposing may be impossible, but I know of a number of tricks that might enable you to create a single layout that can be used to print all of this data that you currently print from two different layouts.