Can you outline the basic relationships involved? That will be a key part of how you might produce the report that you need.
I can guess that you might have:
Property----<Rooms----<InventoryItems----<Pictures (---< means "one to many" )
But could easily be guessing wrong about that.
Pretty much spot on except pictures are not related to Inventory items.
One property to many rooms
One room to many inventory items
One room to many pictures
Too bad, my first guess is much simpler for report purposes...
Without pictures in your report, you can set up a list view report layout on InventoryItems and include fields from Rooms and Property in sub summary layout parts, headers, footers and grand summary layout parts while putting fields from InventoryItems in the body.
The presence of 0 to many related records in pictures, linked to Rooms, complicates the process, however. You can try setting up the report that I just described, but in the sub summary layout part where you'd put fields from Rooms, also put a portal to Pictures. Specify a very large portal with way more rows than you ever expect to need. This will make for a very large sub summary layout part. Then select the portal and set it to "slide up", "resize enclosing part". This portal should shrink down to just the same number of rows as you have pictures when you preview/print or save as PDF.
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.
I've used the large portal method and have almost got it to work. There's a small issue that I can't seem to rectify though.
I currently have the portal spanning 5 pages. The first page containing the portal comes out fine, but on each subsequent page the portal rows move up ever so slightly. By the 5th page, they've moved up to the point they're crossing over the page break.
I've been making tiny changes to layout part sizes, page margins etc but can't get it to stay still.
Hope that makes sense and hope someone has also experienced this.