Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. 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.
    1. If you have never browsed to the server from the designer before, you will need to manually enter the URL the first time
    2. 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
  2. Click Refresh
  3. Select a folder for which you have publish rights and click Ok
  4. If your report published with no errors, you will receive a Publish Successful message dialog. Click Ok to continue. 
  5. 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:

...