Interactive Word Report

Interactive Word Report

This form enables you to specify queries to be used in Word reports, and to produce reports to Word. It is invoked either by choosing Reports/Interactive/Word on the main menu, or by clicking the side-button on the Word Report button and choosing the Interactive option.

 

For a detailed explanation of each of the interface items available on this form, please refer to the corresponding callouts. The basic steps for generating a report are as follows:

 

1. Launch the Word Report form.

 

2. Optionally click the browse (...) button and select the Word document (.dot or .doc file) you want to use as a template. If you don't specify a Word document for this project, the default document you specified in the MS Word Integration will be used. If none was specified there, the Word default (usually normal.dot) will be used.

 

3. Click the Properties button and set the content-to-styles mappings then dismiss the Properties form.

 

4. Optionally link one or more queries to bookmarks in the document. (If no queries are linked, Symphony uses the Default query, which is created when the project is created, and begins producing output at the end of the document.)

 

3. Click the Run All button. Word will open and the report will be produced to a copy of the template file you designated in step 2.

 

1 . Remove LinkRemove Link


This button is enabled when a link exists between the template and the currently selected query. Clicking this button removes the link and the bookmark, so that the query will no longer produce output to this document.

 

2 . Link Query to TemplateLink Query to Template


Links the currently-selected query to the template, or if it is already linked, moves the link to the current cursor position in the Word document. Links determine which queries to output, and where output should begin. To create a link, first click inside the template document where you want to start printing, then click the Link Query to Template button. Symphony will create a bookmark inside the document at the location you clicked.

 

Note: If you link two queries to a document without placing text between them, it is possible that only one of the queries will be produced. This is because

 

3 . Run QueryRun Query


Clicking this button executes and outputs the currently selected query to a new document. A copy of the report template is created inside Word and becomes the active document. While the report is being generated, the controls on this form are disabled, except for the Cancel button.

 

4 . Report TemplateReport Template


This is the name and location of the file that will be used as a template for the report. When Symphony generates a Word report, a copy of the template is made and Symphony generates the report to the copy.

 

5 . List of QueriesList of Queries


Contains an entry for each query defined in the project. Queries are defined in Statistics view. You can jump from here to a query in Statistics view by right-clicking on the query and choosing Go To Query from the context menu.

 

6 . Include Header in OutputInclude Header in Output


If this checkbox is checked and if Table is specified as the Output format, a header row is generated.

 

7 . Output as TableOutput as Table


Specifies for the query to be output to Word in a table format. This produces a "flattened" view of the data, where each row in the table contains repeating data. For example, a query consisting only of columns for Category and Comment would produce a row for each Comment, with the Category repeating where the Category is the same.

 

About the Respondent List query

This is a special query that is created by Symphony when you create a project. When it is included in a Word report, it is always output in a tabular format, regardless of the settings on this form.

 

8 . Browse ButtonBrowse Button


Click this button to locate a Word document or template you want to use as a template for your report.

 

9 . Output as Coded StructureOutput as Coded Structure


When this button is selected, the query is output as a hierarchy based on the coding structure -- equivalent to what you observe in Report View. When the report is generated, Symphony outputs formatting instructions to Word, based on the Word Styles you set in the report Properties.

 

10 . Run All QueriesRun All Queries


This button has the same effect as for the Run Query button, except it causes all queries that are linked to the active template to execute. If you have more than one query linked to a query, this is the button you want to click when you want to run a complete report.

 

11 . Cancel QueryCancel Query


Click this button if you wish to stop a query from running before it is complete.

 

12 . New Word TemplateNew Word Template


Clicking this button enables you to begin defining a new template. When the button is clicked, Symphony creates a new document based on the current default document you have set up, brings up the Properties form so you can change Style mappings between the document and Symphony if desired, and then document is set as the active document in Word so you can begin editing the template and linking queries to it.

 

13 . Template PropertiesTemplate Properties


Clicking this button brings up the Properties form for defining the styles mapping between the template and Symphony. The template properties form is identical to the MS Word Integration tab in the Symphony configuration, only the settings pertain to the current template, where as the MS Word Integration settings serve as global defaults.

 

14 . Word Bookmark if LinkedWord Bookmark if Linked


Symphony uses Word bookmarks to track where output is to start within a document. (If you are not familiar with Word bookmarks, they are accessible in Word by clicking on Insert/Bookmarks.) When a query is linked to a document, a bookmark is created inside the Word document and its name is displayed here.

 

Copyright (c) 2008 Active Java, LLC. All Rights Reserved.