Yes, Create a main Report, and sub report seperately.

Open the Main Report and in Insert menu, select subreport

option, and in that "select an existing report",select the

sub report which is already created, and pt the link

between Main report and sub report with the required

fields. Now Export the report to Excel format.......