Stop Details Sections from Alternating

[Hviezdoslav]

Please bear with me because I am very new to Crystal Reports. I am using version XI.

I have a report that has two Excel files as data sources. I have hidden everything in design view except Details A and Details B. On Details A, I have the 3 fields from the first Excel file. On Details B, I have the two fields from the second Excel file. I only have two records in each Excel file and these two Excel files have nothing to do with one another.

In Section Expert, I have nothing checked for the Details, but I have Keep Together and Free-Form Placement checked for Details A and Details B.

When I preview the report, I see a record for Details A, then a record for Details B, then a record for Details A, et cetera. The report shows the 1st record of Details A, then the first record of Details B, then the first record of Details A, then the second record of Details B, then the second record of Details A, then the first record of Details B, then the second record of Details B, then the second record of Details B.

Does anybody know how I can keep Details A together to show its two records and then keep Details B together to show its two records? I want each of the two details sections to be separate from one another and to not alternate.

In Report/Group Expert, I have nothing. I am not trying to Group By.

Please pardon my ignorance as I am a newbie.

Thanks very much in advance,

hviezdoslav

 

[lbass]

Try using only one of the files in your main report. Then insert a subreport that uses the second file and place it in the report footer.

-LB

 

[Hviezdoslav]

Thanks very much to you, LB!

I tried what you suggested and it works. I kept the Details A of the main report for the first Excel file. I deleted from the main report the Details B that had the second and unrelated Excel file. I deleted the 2nd Excel file that was connected to the main report.

I created a sub report in the main report's Report Footer and connected it to that 2nd Excel file.

Now I can show separately in one report the records from the first Excel file and the records from the second Excel file.

Thanks again to you, LB.

hviezdoslav