How to group and display records in new pages in NAV 2018?

Hi friends,

[Version: NAV 2018]

I am designing a report (Visual Studio) to extract records from G/L Entry. The records has to group based on G/L Account No. and Dimension Value of Global Dimension 2 Code (Department Code). In the report, I need to export each Dimension Values in new-new pages. Also, while exporting to excel, it has to print in different worksheets of same spreadsheet. What is the way to do so?

Thanks in advance, Aarvi.