Printing a portal

[ilnave]

Hi all, I have searched the forum without finding answer to my doubt.

I am setting up an invoicing system with FM10, and I have two tables, one with orders and one with line items.

I have set an input layout where the user inputs in a portal the line items for each order.

Now I am setting up a print layout, the idea is to print a table with all the line items of a record. The table should be dynamic and show as many lines as the line items in the order.

I think that the idea is to put column names in the header and than line item fields in the body. Unfortunately it shows only the first line item.

How can I obtain what I am trying to do?

Thank you, regards

[efen]

Something like the attached?

[Zcast]

Will someone please fix the problems with downloading sample files on this forum!!!!!

Unable to download the file ONCE again!!!!

[djlane]

Ilnave,

A few pointers.

1. You should not use a portal to print invoice line items.

2. Your layout should be based on the line items table, not the header / parent table.

3. You need to use a LIST layout.

There are several Invoicing solutions out there where you can see how invoices are printed. This one is free : http://www.fmstartingpoint.com/

[ilnave]

sorry for my late reply, I did not receive email notifications.

I have trouble downloading the file.

Thanks

[ilnave]

Hello djlane,

thank you for your help:

1) I am not printing the portal

2) I am selecting the "line items" table

3) Indeed, the list layout automatically "designs" the layout as I meant, BUT it shows only the first item , why?

thanks

[ilnave]

Ok, there are a few updates.

I have two related tables, one with orders and one with line items for each order. Data input happens through a portal for line items.

My need is to setup an invocing layout.

I understood that the correct layout is the list layout, which puts in the body the order line items.

Everything perfect... except... it only shows the first line item of a certain order, not all of them

Anyone can help? thank you

Regards

[efen]

Attached is the file that can't be downloaded in the previous post.

orders.zip

[ilnave]

Thank you, and sorry for my late reply, I am not receiving notifications, and have to fix this as well!

I have downloaded the file, but how can I edit it in order to see how it is built?

I cannot see any layout feature if it remains in user mode.

Regards

[ilnave]

ops