January 4, 200917 yr 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?
January 4, 200917 yr 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.
January 4, 200917 yr Author i did nor sussed doing it i upload the file can u help me? mc_barter_copy.fp7.zip
January 4, 200917 yr Author thank you . if you see order 24 has 2 orderlines it do's not show it why?
January 5, 200917 yr 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.
January 5, 200917 yr Author 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.
January 5, 200917 yr 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?
January 5, 200917 yr Author 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
January 5, 200917 yr 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, 200917 yr by Guest
January 5, 200917 yr Author it is grate can u explain how u did it please? that i can do it from the beginning. Edited January 5, 200917 yr by Guest
January 5, 200917 yr 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.
January 5, 200917 yr Author you are grate thank you . i What to ask u whay i can see that info in find mode? Edited January 5, 200917 yr by Guest
January 5, 200917 yr Author 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
January 6, 200917 yr 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.
Create an account or sign in to comment