Dani R Posted January 4, 2009 Share Posted January 4, 2009 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? Link to comment Share on other sites More sharing options...
RalphL Posted January 4, 2009 Share Posted January 4, 2009 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. Link to comment Share on other sites More sharing options...
Dani R Posted January 4, 2009 Author Share Posted January 4, 2009 i did nor sussed doing it i upload the file can u help me? mc_barter_copy.fp7.zip Link to comment Share on other sites More sharing options...
RalphL Posted January 4, 2009 Share Posted January 4, 2009 Take at look at this. Is this what you want? mc_barter_rhl.fp7.zip Link to comment Share on other sites More sharing options...
Dani R Posted January 4, 2009 Author Share Posted January 4, 2009 thank you . if you see order 24 has 2 orderlines it do's not show it why? Link to comment Share on other sites More sharing options...
RalphL Posted January 4, 2009 Share Posted January 4, 2009 I see 2 order lines for orders 20, 24 & 29. Link to comment Share on other sites More sharing options...
Dani R Posted January 5, 2009 Author Share Posted January 5, 2009 I need to see them in the same page. Link to comment Share on other sites More sharing options...
RalphL Posted January 5, 2009 Share Posted January 5, 2009 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. Link to comment Share on other sites More sharing options...
Dani R Posted January 5, 2009 Author Share Posted January 5, 2009 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. Link to comment Share on other sites More sharing options...
RalphL Posted January 5, 2009 Share Posted January 5, 2009 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? Link to comment Share on other sites More sharing options...
Dani R Posted January 5, 2009 Author Share Posted January 5, 2009 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 Link to comment Share on other sites More sharing options...
RalphL Posted January 5, 2009 Share Posted January 5, 2009 (edited) 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 Link to comment Share on other sites More sharing options...
Dani R Posted January 5, 2009 Author Share Posted January 5, 2009 (edited) 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 Link to comment Share on other sites More sharing options...
RalphL Posted January 5, 2009 Share Posted January 5, 2009 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. Link to comment Share on other sites More sharing options...
Dani R Posted January 5, 2009 Author Share Posted January 5, 2009 (edited) 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 Link to comment Share on other sites More sharing options...
Dani R Posted January 5, 2009 Author Share Posted January 5, 2009 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 Link to comment Share on other sites More sharing options...
RalphL Posted January 6, 2009 Share Posted January 6, 2009 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5561 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now