...
- From the OfficeWriter Designer toolbar select Save. You will have the option to Save to Disk or Deploy to Remote Server.
# Select Save to Disk.
# Navigate to a local folder where you will store the template report file. This will be where you store your work file in case you want to edit it later, not a location on the Reporting Services server.
# Save the template as an RDL file.
# To publish the report, from the toolbar, click Save and select Deploy To Remote Server.
# From the Publish dialog box select the drop-down to display the Server or URL.
# If the dropdown contains the server you need, select it.- If you have never browsed to the server from the designer before, you will need to manually enter the URL the first time
- Use the Web Service URL, which can be found in the SSRS Configuration Manager on the report server. It usually looks something like this: http://<servername>/ReportServer, or if there is a named instance of SQL Server, http://<servername>/ReportServer_IntanceName
- Click Refresh.
- Select a folder for which you have publish rights and click Ok.
- If your report published with no errors, you will receive a Publish Successful message dialog. Click Ok to continue.
- To view the report, click View on the OfficeWriter Designer. The report viewer will open another Excel window with the report results. It should look like this:
Select Close Report View to return to your report template.
To verify that your report is actually running on Reporting Services:
...