We converted one of our solutions to FM 12 from FM 11. There is a report layout with body records that contain a portal that can display 3 or 4 child records. The portal row contains 3 text fields. The layout objects are set to slide up and reduce the size of the enclosing part. The report has worked correctly FM 3-11.

The problem is that the child records in the portal rows sometimes fail to display in preview mode. Some records display the child records in the portal, others display only the first record.

The portals display correctly in browse mode as list view or form view, Remove sliding, they display correctly in preview.

I have rebuild the portals on a new layout, enlarged them, exported the affected child data to Excel and reimported, nothing seems to help. I have exaggerated the space between the object borders to avoid overlap issue. some portal rows will not display in preview mode with sliding on.

Suggestions?

I have further determined that the loss of data in portal rows when sliding is on and the document is in preview mode is related to the fact that the TO for the portal is based on an external FileMaker Data Source. To test, I created a portion of the external file's fields in a new table in the same file as the parent record table and imported some data. Switching the portal to display the child records from the new TO from the same file as the parent record showed no loss of data.

I found another issue related to creation of records in a layout based on a TO from an external file but I will report it separately.

If your tables are in a single file, no worries. If you are utilizing any degree of data separation, there is reason for concern.

I've had some portal craziness going on with FMP 12 today while I was accessing a file hosted on FMP Server through a VPN, all of the tables were in the one database.

Portal data kept disappearing after a certain record number...which kept changing. I first realized it after I saved as PDF. Then I noticed it was previewing and in browse mode that the portals were empty, only after a certain record. I moved the portal a little to be further from the part separation, didn't matter. Saved as PDF again, still a problem. The file got disconnected, then I went into layout mode again, went back to browse mode... and the data was back. Saved as PDF and it was fine.

I dont think it was the relationship beause there is another field on the layout from the same relationship which is a sum of what shows in the portal and the sum showed the whole time.

We converted one of our solutions to FM 12 from FM 11. ...

Please update your profile to reflect your current FileMaker version and OS.

Update Profile Link