Portal replacement

[pspafford]

Hey kids.

I'm having the same problem that Wald had in the "drifting portal rows" thread. My problem is that I need to print information from two portals in one report:

I have a file called Docket. The Financial Summary report in Docket has one portal that lists all of the invoices and their amounts for a project, from the file Invoice. It also has a second portal that lists all of the purchase orders and their amounts for that project, from the file PO. I only need it to show the first six invoices and the first six PO's

I know that there has to be a way to show this information through calculations, relationships and serial numbers, but I can't seem to wrap my brain around it.

Thanks.

Paul

[LiveOak]

You are probably trying to be too clever. The ultimate approach to printing anything in a report is pretty brutal. Create a separate file with no records. For ultimate flexibility, you can make each record just one or more blocks of text. Build the report explicitly, text block by text block, in the empty file. Not very elegant, but you can generate a report from any number of files without really any relational structure.

-bd

[pspafford]

Oh yuck! That is just an UGLY answer!