Default OfficeWriter Designer for Excel
You will find the OfficeWriter Designer toolbar on the Excel ribbon, under OfficeWriter Designer.
Open Report |
The Open Report button allows you to open saved report definition files (RDL files). These files can be created with the OfficeWriter Designer, Visual Studio, or Report Builder. Open files from your local disk or from a remote server. |
|
Import Template |
New in 8.6 The Import Template button allows you to import an existing DOC, DOCX, or DOCM file and use it as the template for the RDL. This will remove any existing design information. |
|
Save |
The Save button provides the option to Save to Disk and Deploy to Remote Server. |
|
View |
The View button sends a request to Reporting Services to run your report, then displays the results in another window in Excel. If you click this button with an unpublished report open, you will be prompted to publish before viewing. |
|
Data Markers |
The Data Markers button provides a list of the datasets in the RDL file. |
|
Formulas - Expanded |
The Formulas button displays formulas that are available in the RDL. |
|
Help |
The Help button provides links to information about the OfficeWriter Designer toolbar. *About OfficeWriter* will display the version of the Designer toolbar. *OfficeWriter Documentation* is a link to the OfficeWriter Docs. |
|
Help Settings |
The only setting currently available through Help > Settings is whether to show or hide Enterprise Edition features (e.g. Formulas) |
|
MS Query enabled functions
By default, Ms Query functions in the OfficeWriter Designer toolbar are disabled. Instructions for enabling MS Query are available in Using MS Query in Excel to Design Reports.
These functions will be greyed out if the open report was designed in Visual Studio or Report Builder, rather than the OfficeWriter Designer.
Add DataSet |
The Add DataSet button allows you to add datasets to reports designed in the OfficeWriter Designer |
|
DataSet Options |
Selecting Edit DataSet will allow you to edit existing datasets in the RDL. |
|