Display multiple records as sub-sections in the same report.

I am using Crystal Reports (VS-2005).

In a report, I have various sub-sections in the Details section. Each section represents a category and is connected with SQL command which uses LEFT OUTER JOIN.

The first section is the main section and the subsequent sections are the child sections.

Sometimes, a sub-section (other than the first main sub-section) picks multiple records of that category. In this case the report extends to multiple pages. Each report displays one record of this sub-section.

I want to show the the same sub-section multiple times in the same report as opposed to multiple reports that are now automatically generated by Crystal Reports.

How to handle this issue?