In the Export button there is an Send To option.
This option allows you to directly send the information in the report to either a Excel 97-200 (.xls) or Excel 2007 (.xlsx) format WITHOUT having to save the file.
It is similar to Copy & Paste but the advantage of using this option is that it will keep the formatting as seen on screen rather than a straight dump into excel.
How to Use Send To: Once a report has been run:
- Click on the Export Button in the toolbar
- Hover you mouse over Send to option - another window will appear with 2 options
- Select either Excel 97-200 (.xls) or Excel 2007 (.xlsx)
Excel will open and your report will appear.