Page Break in Crystal Report Excel Export

Hello,

I have a report and a subreport inside it.

I have placed the subreport in Report Footer B.

I want the main report in Sheet 1 of Excel and subreport in Sheet 2 of Excel.I have ticked the checkbox "New Page After" in Paging Tab of Section Expert properties of Report Footer a.

And after exporting all the export is coming in Sheet 1.

Can anyone please help me on this ?

Regards,

Nikhil