...
- 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.
# Choose If the server on which Reporting Services is installed. 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.
...