Page History

You will find the OfficeWriter Designer toolbar under the Excel menu bar,  above your worksheet.
!owdx1.jpg!
{table-plus:enablehighlighting=false|columnAttributes=style="border:0;",style="border:0;",style="border:0;"} | *1.* | !owdx2.jpg! | 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.* | !owdx3.jpg! | 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.* | !owdx4.jpg! | 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.* | !owdx5.jpg! | 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.* | !owdx6.jpg! | 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.* | !owdx8.jpg! | The *Insert Merge Field* button places your [data markers|Adding Data Markers] (data placeholders) in the worksheet. |
| *7.* | !owdx9.jpg! | One of the powerful features of [OfficeWriter Enterprise Edition|OfficeWriter Editions] is the ability to [create and use formulas|Adding Formulas to an Excel Report]. The *Insert  	Formula* button lets you select formulas and insert them in a worksheet. |
| *8.* | !owdx10.jpg! | 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.* | !owdx11.jpg! | 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.* | !owdw12.jpg! | 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.* | !owdw13.jpg! | Click the *Help{*}button to open the OfficeWriter Designer documentation. |
{table-plus}