Using 2 Different Tables in a Database to Create One Cystal Report

[snorgaard]

I have an application that uses Crystal Reports to print a report that contains account information. The problem that we were having was the data listed in the report contained 49 records but only one record was being placed in the report. We found that in Crystal Report Versions before 8.5 a developer could retrieve data from 2 different table in a database to get information for one report. If we changed the report using version 8.5 to get all 49 records then we were not able to get a name from the other table in the header information of the report. The question that I have is "Can a developer only get data from one table instead of multiple tables when using the new version 8.5 of Crystal Reports even though a user could get data from 2 tables in earlier version of Crystal Reports?"

 

[balves]

You can certainly join a large number of tables in any report.

What database are you using and what driver did you pick when you created the report?

Is it an equi-join or a left/right join?

 

[Roadkill150]

It does sound like a join issue. I would suggest going into the visual linking expert, and select your link between the two tables, change the link to either a left outer join or right outer join if you are using a connector that allows you that option. The default join type will be equal Seagate Certified RCAD Specialist.
-Bruce Thuel-Chassaigne
roadkill150@hotmail.com