THe presence of two join table to facilitate two many to many relationships is why this is anything but simple. If you report just needed details from Project and Research_Trips, your report could be produced from a found set of records in Join_1. But you also want to liat data from the Research_Details table. Since any given Research detail can be a detail for any number of trips and any number of projects, this becomes a potentially complex issue.
First cut at producing the needed report would be to create a report from the join_1 layout and use a portal to Research_Details to list all of the research details. If printing or saving as PDF from that layout, you can make the portal many rows of data tall and set it to slide up and to resize the enclosing part.
Such data could be exported as text to be opened and edited in Word, but many quite sophisticated reports are possible straight from FileMaker so it may not be absolutely necessary to do that export.
I'm finding that this portal solution will get the job done.... Using merge fields and a bit of slick formatting, it's quite close to working and the portal looks fine. (For newbies who've torn their hair out: you actually CAN make your report look like plain paper in spite of the themes. Right click the "Body" tab in the left hand margin and set the fill-color to white.)
But I'm having some trouble because the portal doesn't seem to want to shrink with less data. Some reports have five details and others thirty, and the portal won't shrink or expand around the amount of data. I set it to resize the enclosing part, but it doesn't seem to want to do that, so I'm stuck with 8 lines or so of blank space in some reports.
Am I missing something easy?
Sliding fields and portals in FileMaker cannot expand, they can only shrink. Thus you over size your sliding stuff to be larger than you expect to need even for extreme cases and then set them both to slide up and also to resize the enclosing part.
And Portals are a special case. Sliding will enable you to get A portal to reduce down to just the needed number of portal rows, but you can't set a field inside the portal row to slide. For example, if some of the data in your portal row might need two text rows of height instead of one, you can't size the portal row and field for two rows of text and set the field to slide up/resize--you'll end up with the larger portal row size in each portal row where you have data.
Key facts about sliding layout objects:
- It's only visible in preview mode and when you print/save as PDF...
- Sliding fields will shrink but not expand.
- All layout objects below and in the same layout part as the slide/resize field need to also be set to slide up and resize.
- Objects in headers and footers will not slide.
- Portals will shrink/slide to fit the number of rows of records, but fields within the portal row will not shrink/slide.
- Fields will slide up only if Top alignment is specified for it and will slide left only if Left alignment is specified.
- Consistent side borders are difficult to achieve with sliding fields.