Jump to content
Sign in to follow this  
Dani R

help me whit a invoice

Recommended Posts

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

thank you .

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 by Guest

Share this post


Link to post
Share on other sites

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

Edited by Guest

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

you are grate thank you .

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

Edited by Guest

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.