FRS- Need to display the output in excel in different tabs for different branch values

Summary:

There is a requirement for an FRS report (Income Statement with Budget). Currently, when a user selects a specific branch (e.g., Deloitte Delhi) in the parameter, the report successfully generates an Excel output with that branch's data in a single tab. This functionality is working perfectly.

The new requirement is to extend this capability to scenarios where the user selects "All Branches" in the branch parameter. In such cases, we need the Excel output to present each branch's income statement on a separate tab.

We are using Smart View to execute these reports and achieve the separate tab output for different grids in the FRS report.