Print Page | Close Window

Join Issue Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Report Design Forum Discription: The best way to design a report and problems you have encountered URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21678 Printed Date: 03 May 2024 at 4:32am Topic: Join Issue Posted By: jsh8286 Subject: Join Issue Date Posted: 11 Sep 2015 at 4:14pm Have two tables - Table A and Table B. Table A contains Customer Information - for example: Cust   Doc#    Amount   Transaction Type      ShipToCode ABCCO 12345   100.00    IN (Invoice)           1 ABCCO 23456   200.00    IN (Invoice)           2 ABCCO 2354     50.00    CN (Credit Note)       2 Table B contains the same information but has extra transactions pertaining to payments of the above invoices. So for example: Cust    Doc#    Amount   Transaction Type ABCCO   12345   100.00   IN ABCCO   23456   200.00   IN ABCCO   2354     50.00   CN ABCCO   PY12345 100.00   CA I want a report where I can connect the two tables to include all of the fields in table A and add just the "CA" transaction type for table B. But as soon as I try to mix the different tables the report goes blank. I assume a linking issue of some sort but can't figure it out. Thanks in advance for any input. Replies: Posted By: DBlank Date Posted: 14 Sep 2015 at 3:53am do you want to JOIN this or UNION it? Posted By: jsh8286 Date Posted: 17 Sep 2015 at 10:04am sorry for LATE response...join

Print Page | Close Window