SUB REPORTS AS NEW SHEETS IN EXCEL

• Insert  rectangles below the main report the no of rectangles equal to no sub reports
• In rectangle properties add a page break before(this makes a seperate sheet in excel)
• Insert a sub report into the Rectangle
• Add parameters to the sub report
• To rename sheets in the rectangle properties(right side) add page name