HI I am using Crystal report 2016, I am getting my Database thru SQL server and application is Prism G2.
I have 2 Tables PO_Item (itemized), Purchase_Order (Summary with Vendor and other terms)
I get my PO details in PO_Items and insert it to the detail section. When ever I insert a field PO_items.PO_ID in the report Header I am getting the correct preview of all the items in a particular PO. I need to display the Terms, vendor, vendor address to the report header as well and will get it from the table Purchase_order. Once I insert the filed vendor, vendor address and terms to the report header from table Purchase_Order my details are getting hay wire, it multiplies the number of filed I inserted. I know that adding a field to the Report header form another Purchase Order table creates the multiplying of items because when I deleted the fields from the report header it goes back to the correct preview.
The thing is I need the Vendor, Vendor Address the Terms and delivery terms in my PO Form, but this causes the problem. How do I correct this.
Is there a way to make this field read only or use this field but will not affect the details.
I did not use any linkage from one table to another, because if I do auto Link, the PO will be blank.
Can somebody explain to me the principle of Linking Tables and tips on how to link table properly (what to remember and to do etc...)
One last thing is the first page of my PO form is the Purchase order Cover form which is positioned to the whole Report Header, my problem is it does not show the footer, I thought it was just the margin but when I lowered the margin in only shows on the succeeding page, did I missed something? Please help...