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 ?