I need a strategy for printing portal rows in a report. I know you can get a portal to slide and shrink, but not the contents of the portal.

As it stands now, I include a portal object in a report layout that includes a large number of other objects (other fields and graphic items). I may have any number of portal rows that I need to print in my report. Also, the size (number of printed lines) for each portal row can be from 1 to 12 lines. If I make each portal row of a size to include 12 lines, each row that prints takes up 12 lines even if a particular row is only 1 line. Of course this makes the printed page unacceptable.

Is there a scripting method &/or calculation field method to accomplish this task?

The strategy is to print from a layout in the related file using a simple list view (or a summary report if the needs are more complex). Use a relationship back to the master file to bring in the necessary data and graphics.

Another method is to concatenate the related info into a calculation field using the ValueListItems() function. This works well sometimes, its main limitation being that it will not display duplicate values (the function indexes the related records, so duplicates are displayed only once). This won't work for images though.

Thanks for your reply. I've been on vacation or I would have responded sooner. I have been reading responses to my type of problem and I get it now.

Don't print portals.

Print related records from the related file.

Randy Figurski

Reno, Nevada