Page History

h2. Default OfficeWriter Designer for Word

You will find the OfficeWriter Designer toolbar on the Word ribbon, under *OfficeWriter Designer*. 

!UpdatedDesigner8_6.png!

{note}
As of OfficeWriter 8.1, the OfficeWriter Designer is intended for use in Word 2007 and later. If you are using Word 2003, you will need to use OfficeWriter Designer 8.0.0 or earlier. An explanation of the 2003 toolbar is available under [The OfficeWriter Designer for Word 2003].
{note}

{table-plus:enablehighlighting=false|columnAttributes=style="border:0;",style="border:0;",style="border:0;"}


| *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.  \\ \\ | !open_report.png! \\ \\ |
| *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.  \\ \\ | !ImportTemplate.png! \\ \\ |
| *Save* | The *Save* button provides the option to *Save to Disk* and *Deploy to Remote Server.* \\*Save To Disk:* save your template as an RDL file. \*Deploy To Remote Server:* Publish your report on the Reporting Services server. Once you do this, your report will be available for viewing in Excel and through Reporting Services Report Manager.  \\ \\ | !save_options.png! \\ \\ |
| *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.  \\ \\ | !view_report.png! \\ \\ |
| *Merge Fields* | The *Merge Fields* button provides a list of the datasets in the RDL file. \\\  Hovering over one of the data sets will bring up the *Merge Field Menu*. | !mergefield_datasets.png! \\ \\ |
| *Merge Field Menu* | Selecting a field from under *Insert Merge Field* will insert the merge field for that query field into the Word document. \\ \\ *Show Current Repeat Region* will highlight the section of the document that is set to repeat for each row of data in the current data set.  \\ \\ To use *Set Selection to Repeat Region*, select a region of the document contain the merge fields for the current data set, then select *Set Selection to Repeat Region*. This will place a bookmark around selected region that will repeat for each row of data in the current data set. \\ \\  *Clear Repeat Region* will remove a bookmark that was added with *Set Selection to Repeat Region*. \\ \\ If a data set is not set to repeat, only the first row of data for the data set will be imported. \\ \\ | !mergefield_options.png! \\ \\ |
| *Formulas - Expanded* | The *Formulas* button displays formulas that are available in the RDL. \\Selecting a formula under *Insert Formula* will insert a data marker for that formula into the Word report. \*Add Formula* will allow you to build new formulas and *Edit Formulas* will allow you to manage (create, edit, remove) formulas.  \\ \\ | !formulas.png! \\ \\ |
| *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_options.png! \\ \\ |
| *Help Settings* | The only setting currently available through *Help* > *Settings* is whether to show or hide Enterprise Edition features (e.g. Formulas)  \\ \\ | !settings_options.png! \\ \\ |

{table-plus}

h2. 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 Word 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.

{table-plus:enablehighlighting=false|columnAttributes=style="border:0;",style="border:0;",style="border:0;"} | *Add DataSet* | The *Add DataSet* button allows you to add datasets to reports designed in the OfficeWriter Designer \\ \\ | !enabled_dataset.png! \\ \\ |
| *DataSet Options* | Selecting *Edit DataSet* will allow you to edit existing datasets in the RDL. \\ Selecting *Delete DataSet* will remove the query from the report file (RDL). It will not remove data markers from that dataset. \\ \\ | !msquery_enabledfull.png! \\ \\ |
{table-plus}