BrightWork Reporter can export directly to Microsoft Excel with report formatting (including Grouping) intact. This allows you to manipulate the report data in Excel and to share report data with individuals who do not have access to the project site where the report is displayed.
To export to Excel, click Export | Static Excel on the Reporter ribbon. This will open the File dialog where you will have the option of either opening the Excel file directly or saving it to your hard-drive.
Note: Reporter Filters are not supported when exporting report data.
Icon columns (e.g. Progress Bar) are not included in the export.
The Project Link and Project Link Icon Columns are also not exported by design. These internal tracking columns are based on the computed column type and are calculated on the fly when rendering the item.