I'm working on a (supposedly) simple invoicing database and I've made good progress thanks to the help I've had in this forum. I have an Invoices table and a lineitems table. I have a portal on the invoices table showing quantity, description and price from the lineitems table. In browse mode, everything is showing up in the right places. However, if I try to print or if I view in Preview mode, none of the portal rows show up. I've looked at Sliding/Printing but the items aren't checked to stop them printing.

Any ideas?

Regards

Andrew

I don't know what is causing your problem, but portals aren't designed fro printing. I suggest that you print the invoice from the lineitems table. Use the list/report layout. You will get a better report.

I realise that the list/report layout is the way to go, but I'd still be interested in finding out why I can't get a quick and dirty printout from the portals.

Thanks

Andrew

This is strange. Despite it not being the recommended way I always print my invoices with a line-items portal in the body and have had no problem. Is it possible that your portal is overlapping a summary part - although I'm not sure that would cause this problem.

No, there's no summary part in the layout. The weird thing is that all the portal fields are displaying as they should in browse mode, but all portal fields are empty in preview mode.

Andrew

When you go to the preview mode you go to the first page. Is it posible that the first page has no related records.

Try this little procedure:

Show all records

Omit current record

Show omitted

Enter preview mode

Now you should only see the current record in the preview mode.

Ralph is right. The records in portal are not reflected in preview mode unless the current record is the only record in the foundset.

If the portal contains a scroll bar and the number of records could be more then the number of portal rows displayed or if you don't want to do show all records then I would advise to print the records from the child file directly which would help you to see all the records with header information from the primary file.

Hi Ralph,

You were right. Great catch. It works when I follow your instructions. That's certainly not something that's intuitive.

Thanks

Andrew