Skip to end of metadata
Go to start of metadata

You will find the OfficeWriter Designer toolbar under the Word menu bar at the top of your document.

1.

The Open Report button allows you to open saved report definition files (RDL files). These can be files created with OfficeWriter, Visual Studio, or another tool. You can open RDL files on any drive your computer can access, as well as from any accessible Reporting Services server.

2.

The Add Query button allows you to add new database queries to your report template. If you opened a report definition (RDL file) that was not created by OfficeWriter Designer (for example, an RDL file created in Visual Studio), the Add Query button will not be active.

3.

Click Edit Query to modify a query created with OfficeWriter. Your original query will be displayed so you can add or remove fields, change sort order, or edit the SQL statement. If you originally created your report definition using OfficeWriter Designer, you can change your queries at any time. If you opened a report definition (RDL file) that was not created by OfficeWriter Designer (for example, an RDL file created in Visual Studio), the Edit Query button will not be active.

4.

Use the Delete Query button to remove a query from your report template. If you opened a report definition (RDL file) that was not created by OfficeWriter Designer (for example, an RDL file created in Visual Studio), the Delete Query button will not be active.

5.

When working with a report with more than one query, the *Select Query* button displays a pulldown list of all the report's queries. Select the query you wish to work with before adding fields or setting query range.

6.

Click Query Range to set a query's range to either Document or Selection. If a query is set to Document range, only the first row of data is returned from the query. When you set a query to Selection range, the query will return all the rows to the report.

7.

The Insert Merge Field button places your merge fields (data placeholders) in the document.

8.

One of the powerful features of OfficeWriter Enterprise Edition is the ability to create and use formulas. The *Insert Formula* button lets you select formulas and insert them in the document.

9.

After you create or change a report, the Save As button allows you to save your report document as an RDL file - an xml-based report definition. If you use Word's menu bar to save your document, you will only save a copy of the Word file itself without any report information.

10.

Use the Publish button to publish your report on the Reporting Services server. Once you do this, your report will be available for viewing both in Word (through the OfficeWriter Designer) and through Reporting Services Report Manager.

11.

The View button will execute your published report and display the results in another window in Word. If you click this button when you have an unpublished report file open, you will be prompted to publish before viewing. If you open Word and have no active documents open, the View button will serve as a report browser, allowing you to view any report on your report server.

12.

Click the Help button to open the OfficeWriter Designer documentation.

  • No labels