Page History

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

!ribbon.jpg!

{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.jpg! \\ |

 | *Save* | The *Save* button provides you the option to *Save Toto Disk* orand *Deploy Toto Remote Server.* | !save_top.jpg! \\ |
|  *Save Options* | *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.jpg! \\ |
|  *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.jpg! \\ |
|  *Data Markers* | Provides a list of the datasets found in the current RDL file. |!data_markers_top.jpg! \\ |
|  The *Data Markers - Expanded* | *Data Markers* button provides a list of the datasets in the RDL file. \\Navigating and hovering over one of the datasets will expose the fields in the dataset query. \\ \\ Selecting a field from under *Insert Data Marker* will insert the data marker for that field into a cell. \\ \\ Selecting  *Insert All* will insert data markers for all the fields in a single row of cells in the Excel report. | !data_markers_expanded.jpg! \\ |
|  *Formulas - Expanded* | One of the powerful features of OfficeWriter Enterprise Edition is the ability to [create and use formulas|8.1 - Adding Formulas to an Excel Report]. |!formulas_top.jpg! \\ |
|  *Formulas - Expanded* | Select a formula to insert it 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 Excel report. \\ \\ *Add Formula* will allow you to build new formulas and *Edit Formulas* will allow you to manage (create, edit, remove) formulas. | !formulas_expanded.jpg! \\ |
|  *Help* | The *Help* button provides links to information about the OfficeWriter Designer toolbar, provides access to some settings, and links to documentation. |!help_top.jpg! \\ |
|  *Help - Expanded* | Description|!help_expanded.jpg! . \\*About OfficeWriter* will display the version of the Designer toolbar \\*OfficeWriter Documentation* is a link to the OfficeWriter Docs. | \\ |

{table-plus}

h2. MS Query enabled

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


| *number* | image | Description |
{table-plus}