Getting the portal to expand for printing

[SteveGriff]

Hi people

I have this invoice type layout where I have a portal in it. The portal has more records in it than it can handle so it uses the scrollbar.

The question is - I want to print out the invoice layout. Is their a way to tell the portal to expand so it displays all related records while pushing eveything underneath it down?

Please help.

Thanxs again (and again and again...)

Steve Griff

[BobWeaver]

The usual way to do this is to print from the line items file. You can create a reverse relationship back to the main invoice file so that you can display the customer name, address and general invoice info in a sub-summary part.

[SteveGriff]

The only question I have is, when I've placed all my Invoice related fields into my Line Items Database, how do I show all the related items in one layout?

Since each line item would be it's own record, would I have to create a self relationship for the line item to view them in a portal?

Do I just get the same problems? Am I missing something here?

Thanxs

Steve Griff

[Rigsby]

If you use a script in the file where your portal is (i.e. the layout you actually want to print) to go to the related file and at the same time to go to a list layout in that file, you can tell the script (the option is there under the option “go to related record” in script maker) that you only want to see the related records in the other file. You can then draw all the information from the file (layout you really want to print – I presume this is less than the list) into the header or footer parts of your list using a backwards relationship, and print.

I don’t know your FM level; so I’ve described this pretty vaguely – but if you want a full explanation, send me a mail. I’ll try to help.

Rigsby