I've written 2 custom crystal reports based on the AR_InvoiceHistoryDetail and AR_InvoiceHistoryHeader. I want the company name to print on the header of the reports but don't see a natural link that could be applied. I've tried linking one of the tables from AR_InvoiceHistoryHeader to the CompanyName field in the SY_Company table specifying the link as Inner Join not equal to != but when I run the report I see all 4 company names, not on the same page but on various pages, even though the data is coming from the unique history of each company. Is there another way of linking the SY_Company table to the report?
John