FM - Is there a way for a GL Portal to Resize Itself

I have an Income portal and Expense portal in a form layout.  I want to be able to use this layout to print, but the number of records in each portal varies with each main layout record.  Is there a way to make portals resize to fit only the number of portal records they show, or to do so when printing?  If not, what is the workaround?  Thank you.
LVL 2
rvfowler2Asked:
Who is Participating?
 
Will LovingConnect With a Mentor PresidentCommented:
In general, the best way to print records from a portal so that it takes up only the space required for those records is to create a report layout based on the related records  table, which in this case would be your GL table.

Create a script that goes to the report layout, performs a Find for the desired records and then sorts them. You can use a Sub-summary part or sort by Type - Income or Expense - to get them grouped how you want and with an appropriate heading. You could also to a Go to Related Record (GTRR) if you have a relationship between the Main records and ALL related GL records (in addition to the Income and Expense relationships) but it's basically the same as performing the Find and I wouldn't create another relationship just for that if you don't already have one. Just do:

Set Variable [ $MainRecordID ; Main::MainRecordID ]
Go To Layout [ GL Report Layout ]
Enter Find Mode [ ]
Set Field [ GL::MainRecordID ; $MainRecordID ]
Perform Find [ ]
Sort Records [ Restore ]
Page Setup [ Restore ]
Enter Preview Mode [ Pause ]
Print [ ]
Go to Layout [ Original ]
0
 
rvfowler2Author Commented:
Pefect.  Thanks, Will.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.