I am only relatively new to using JDE but have the task of generating a series of reports using Crystal Reports XI. The report I am stuck on uses data from F0902 and F0911. I am using F0902 to create an opening balance field and F0911 to create Invoiced, Payments and Adjustments fields. I am joining using the GBAID, GBLT and GBFY fields. The problem I am encountering is that when F0902 finds (for example) two records that meets my criteria, it then produces all the records from F0911 twice. Does anyone have suggestions regarding my join or any other advice regarding reporting from these two tables?