Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to show records from two different databases in Crystal Reports 2008?


I am a new bie to crystal reports and I am trying to create a report from same table which is from different databases.

I am working on Crystal Reports 2008 and I connected two connections thro Data Base expert. I have two connections now with same table fields say a.empname, a.empsalary from table1 and b.empname, b.empsalary from table2.

I want to render this records in a same report as rows. (both a.empname a.salary as 1st row, b.empname, b.salary as second row in the report)

I tried two details part but it is possible to display the records as rows from two tables in different databases. but the problem if there is a third database having same table and i want to display c.empname , c.salary again in have to go for design.

How to figure out this problem ?


Murali Sri

Former Member
Not what you were looking for? View more on this topic or Ask a question