The OfficeWriter Designer Save option allows the user to either save a local copy to disk, or deploy to a remote server:
Save to Disk will save a copy of the report definition file locally. Deploy to Remote Server will copy and deploy the file to the Reporting Services server where it will be available for renderering.
If you want to render the report in a specific format (XLS, XLSX, XLSM), you will need to use the Save to Disk option to set the file format for the Excel report in the RDL. However, you will only need to do this once to set the file format, unless you decide to change the file format later. The file format options for Save to Disk are:
|
You are now ready to view your report.