I am trying to do a report in crystal that has lots of tables. I have a lead table which can have one or more additional info details listed so I have the join going from the lead table id to additional info lead id. I want to display the lead info regardless if there is a matching record in the additional info table. I have two records in the database for testing. The first contains a record in the additional info table. The second record does not contain any additional info record.
This is what happens with linking:
Equal join: Shows only records where data exists in lead table and additional info
Left outer join: Shows both lead records, but where the record has additional info it hides the subreport and does not show the additional info. On the second record with no additional info the lead info and additonal info subreport show ( no data in subreport as expected)
Right outer join: Shows only records where data exists in lead table and additional info
I am new to crystal but surely this should be a left out join but why when I left outer join is it hiding my subreport with data.
Please help. This is urgent. I am supposed to be going live with this tomorrow morning.