I thank you very much for the reply, DBlank.
Pretend in one Excel file that there are two records for authors, one with the value Dostoevsky and the other with the value Heller. In the second Excel file, there are two records for cars, one with the value Toyota and the other with the value Lexus. Details A has the field for the name of the author and Details B has the field for the make of car.
Before reading your post, I would get the following records when previewing the report and when I did not have the two Excel files connected:
Da Dostoevsky
Db Toyota
Da Dostoevsky
Db Lexus
Da Heller
Db Toyota
Da Heller
Db Lexus
I followed your suggestion and created a field named PK in each Excel file and I connected these fields of the Excel files with the default Inner Join. This helped eliminate some of the records when I preview the report as now I see the following:
Da Dostoevsky
Db Toyota
Da Heller
Db Lexus
Is it possible for me to preview the report so that the data from the two Excel files shows in the following way?
Da Dostoevsky
Da Heller
Db Toyota
Db Lexus
Is it not possible in my case to preview the report with the two records from the one Authors Excel file showing in Details A and the two records from the Car Make Excel file showing in Details B?
Of course I could do two separate Crystal Reports, one Crystal Report for each Excel file. I just wondered if I could use one Crystal Report and show the records of the one Excel file together in Details A and show the records of the second Excel file together in Details B.
Again DBlank, I thank you much for your reply.
hviezdoslav