OfficeWriter Documentation
.
SSRS Integration v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

After a report is published you can view it using the OfficeWriter Designer toolbar, or from Reporting Services Report Manager.

Viewing a Report with OfficeWriter Designer

  1. If the template for the report that you want to view is not already open in Microsoft Excel:
    ## Open Excel.
    ## From the OfficeWriter Designer toolbar, select Open Report.
    ## Navigate to the report definition file that you created with OfficeWriter and open it.
    # Click the View button on the OfficeWriter Designer toolbar. The report will open in another Excel window.
    # Click Close Report View to return to your template.

Report Browsing

Another way to view a report is through Report Browsing:

  1. In Microsoft Excel, close all active documents.
    # Click the View button on the OfficeWriter Designer toolbar.
    # Navigate to the report definition file that you created with OfficeWriter and open it.
    # Click the View button on the OfficeWriter Designer toolbar. The report will open in another Excel window.
    # Click Close Report View to return to your template.

Viewing a Report in Reporting Services

The third way to view a report is from Reporting Services Report Manager. To do this, open your browser and navigate to the Report Manager (usually http://<ReportServer>/Reports). Navigate to your report and open it. Reports created in OfficeWriter Designer will display a message telling you to render the report using the Excel (.xls) designed by OfficeWriter extension.

Icon

What you see on the screen is not the report layout as you designed it in Excel using OfficeWriter. It is only a listing of the raw data returned from your report's queries. If the report definition was originally created with Visual Studio (or another tool) and modified with OfficeWriter, you will see the original layout, not the OfficeWriter layout.

To see the report as you designed it with OfficeWriter:

  1. From the Select a format drop-down list, choose Excel (.xls) designed by Officewriter.
    !xlw_viewreport2.jpg!
    # Click Export.
    # You will be prompted to save or open. To save the report as an Excel file, click Save. To view the report, click Open.
  • No labels