So if you put Station fields right above the Car fields, does it not show the correct information? (just curious)
Also, you might have to have the structure like this: (even though Car isn't actually under Station), because the report mgiht look more ogranized this way.
Job #, Description, Date, Customer, Contact
Group #, Description, Notes ( multiple Per job )
Station, Desc, Width, Height, length, depth ( Multiple per Group # )
Car, Desc, Notes, Photo ( Multiple per Group # )
Position, Desc, width, height, lenght ( Multiple per Car )
You may be able to set up a list view type summary report based on Position and use a portal to Station to list the data from the Station table. There are limits to what you can do with a portal in a report (size it many extra rows in height and set it to slide up | resize enclosing part), but if you can get that to work, it's the simplest approach toward getting what you need here.
Thank you IT_User, But Station and Car are at the same level.
Thank you, PhilModJunk, I will give this a try. Will the portal auto adjust for the number of rows in the station table that is associated to the current group?
For example on group might have 5 stations and the next 23. Givent that the intent is to print ( or save the report ) as a PDF, it would be nice if it adjusted.
If you set a portal to "slide up", "resize enclosing part" on the Inspector's position tab, it will reduce in size to just the number of portal rows needed. The trick is to make your portal many rows taller than you ever expect to need. You might even use a count of the related records in a calculation field or conditional format to display a warning if you ever exceed that maximum number of rows just to be safe.
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.
Much apprecited. This is exactly what I needed. This all makes sence.
I have tried to: set a portal to "slide up", "resize enclosing part" on the Inspector's position tab,
Unfortunaly it does not seem to to shrink (reduce in size) to displsy only the number of rows needed.
I have turned off the " Show vertical scroll bar"
set up number of rows for the portal to be 25
my test records are 7 in one instance and 4 in another and only 1 in another. Howerver the dportal still displays enough space for 25 records.
Is there anothere seting that I am missing?
Thank you for taking the time to look into this.
Were you checking the results in Preview or Browse Mode? Sliding is only visible when you Preview, print or save as PDF.