Show 1 record at time for Crystal Report 11.5

[PointProg]

I have this crystal report set up using XML as the data source. One of my tables in the XML is pretty large. I do not want to show everything on the crystal report, so I decided to break it down to detail sections. Each detail section has a sub report that is using the same table. I broke it down this way to be able to use the selection expert to suppress a section. Hopefully I can explain what I want my report to do, so here I go. Example, I have a table called Sports and I used a vb.net project to add 3 records to my Sports table. My crystal report is broken down to 4 detail sections with the sub reports NFL, NBA, MLB, and NHL. I want my first record to print out the 4 sections, then move on to the next record and have it print out. The problem is it's printing out every record on the NFL section, then move to the NBA record and does the same.
Another note, I have two group made up, one for Main Information and the other one for the Sports table. Any type of help will be greatly appreciated, thanks.

 

[Madawc]

I think you started with the wrong idea. Definitely, it is inefficient to put sub-reports at the detail level.

What you've got is a set of 'rows', all links from an entry in table A to an entry in table B. You can group, suppress detail lines and just show the header or footer.

If you don't want details, adjust the record selection so you don't get them. But this can only be based on a single row.

One report option is to have several successive subreports in the report header or footer sections of a frame report. Would that do what you're after?

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10