Skip to end of metadata
Go to start of metadata

You will find the OfficeWriter Designer toolbar under the Excel menu bar, above your worksheet.

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.

6

The Insert Merge Field button places your [data markers|Adding Data Markers] (data placeholders) in the worksheet.

7

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 a worksheet.

8

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

9

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 Excel (through OfficeWriter Designer) and through Reporting Services Report Manager.

10

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

11

Click the Help button to open the OfficeWriter Designer documentation.

 

 

  • No labels