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 (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. |
