help me whit a invoice

[Dani R]

if i have in table 1 invoice number and in table 2 invoiceLine how can i billed a invoice repot what will show the oderlines by invoice number?

[RalphL]

if i have in table 1 invoice number and in table 2 invoiceLine how can i billed a invoice repot what will show the oderlines by invoice number?

You make your report in table 2. Place the invoice number and other data from table 1 into a Sub-summary via relationship. Sort by invoice number.

[Dani R]

i did nor sussed doing it i upload the file can u help me?

mc_barter_copy.fp7.zip

[RalphL]

Take at look at this. Is this what you want?

mc_barter_rhl.fp7.zip

[Dani R]

thank you .

if you see order 24 has 2 orderlines it do's not show it why?

[RalphL]

I see 2 order lines for orders 20, 24 & 29.

[Dani R]

I need to see them in the same page.

[RalphL]

I need to see them in the same page.

I only see one page for the whole report. I don't understand what you want.

[Dani R]

I what to make a layout that will show is order that has 1 or more line i will see all of the lines of orderline.

[RalphL]

The file that I modified and posted has a layout named report which shows all of the orders and under each shows all of the orders_line for that order.

Is that what you want?

[Dani R]

yes i what to see in the layout report that in the top i will see the order number and in the bottom i will see the orederlines

[RalphL]

yes i what to see in the layout report that in the top i will see the order number and in the bottom i will see the orederlines

I think you want to see only 1 order on a page. Take a look at Report 2. The only difference between it and Report is that I went to layout mode, selected Part Setup from the layout menu and set the Sub-Summary part to page break before every occurrence.

mc_barter_rhl2.fp7.zip

Edited January 5, 2009 by Guest

[Dani R]

it is grate can u explain how u did it please? that i can do it from the beginning.

Edited January 5, 2009 by Guest

[RalphL]

Here are step by step instructions:

Go to Layout Mode

Select New Layout from Layout Menu

Set Show Records from to Orders_line

Name Layout

Select Columnar List/report

Click Next

Click on Report with grouped data

Click on Include Subtotals

Click on Next

Select fields you want to include in the report from this table & Parent table

Click on Next

Set Report Categories to orderIDFK

Click on Next

Set order to orderIDFK

Click on Next

Click on Next

Select Standard theme

Choose Current Date for Top Right

Choose page Number for Bottom Right

Click on Next

Click on Create Script

Click on Next

Click on View in layout mode

Click on Finish

Make adjustments to layout.

Run the script to see the report.

[Dani R]

you are grate thank you .

i What to ask u whay i can see that info in find mode?

Edited January 5, 2009 by Guest

[Dani R]

i have a layout to make the order with a portal ant the end i have a button to send to what you help me with how do i send the order number there?

thank you Dani

mc_barter_rhl21.fp7.zip

[RalphL]

I made a new script and attached it to the button. It uses Go to related record step to limit the records in Orders_line to those related to the order.

You asked about using this layout in find mode. This is not a good layout for finds.