Using Center Pane Options in the Financial Package

Center Pane in the Financial Package

The node selected in the Reports pane determines the display of the Properties pane. The main sections in the center pane are as follows:

Details

• Code - Enter a code, which will appear in the Report pane.

• Due Date - Click the calendar to select the Due Date. The Due Date represents the completion date for the report, group, or section, and controls the status (for information purposes).

• Assigned To - Add users who can add new sections under groups and are responsible for section-level completion.

• Content Type - Select a content type, which determines the type of content within the report. The content type selection determines subsequent content options, including the Parameters pane (right).

Content

• Report Folder - Locate the File Cabinet folder to identify where the report will reside.

• Owner - The owner of the report is the person who created the report by default.

• Participants - Locate the required list of users who need to access and contribute to the report. Subsequently, the Assigned To field within groups or sections retrieves the list of participants defined here.

• Template - Click Browse to select a *.dot file (Microsoft Word Template) or *.dotx file. Financial Package functionality allows you to create a template (with header/footer, watermark, logos, page numbers, text styles, for example) in Microsoft Word and apply it to a Financial Package Report.

The fields below are available for a new section child:

• Table of Contents - Select to automate a table of contents and page numbering based on the document structure. If you want a selected group or section name to appear in the table of contents and as a header within the Microsoft Word document, select this checkbox.

• Page Break - Insert page breaks, which will occur after the section or group.

• Orientation - Control page orientation by section. Select Portrait or Landscape.

• Shrink to Fit - Shrink report contents to fit page specifications.

• Report Display in Output:

  • Table - Select Table to insert the Dynamic Report as an object within the Financial Package report, which allows you to double-click to edit report details. Report Display in Output is not available when Shrink to fit is selected.

  • Image - Select Image to insert the Dynamic Report as an image in the Financial Package report. Images cannot be edited. Selecting Image opens Header & Footer Display Configuration.

    • Header & Footer Display Configuration: Allows you to have repeating header and footer details on each page of your Dynamic Report output in a Financial Package report.

      • Header & Footer section – Select to have the header and footer details displayed on each page of the Dynamic Report in the Financial Package output, which can be Microsoft Word or PowerPoint.

      • Rows – Select to have the header and footer details displayed only once for the entire Dynamic Report in the Financial Package output. The header will be displayed on the first page of the Dynamic Report and the footer on the last page of the report. This is similar to the way Financial report output is displayed.

Content Type

The Content Type selected determines the output on the right pane.

Text - Add text content to your report. Click Search to open the Text pane. The Text pane resembles a Microsoft Word document, enter text and modify as desired. Formatting options are preserved.

Default options are used as well as the order of precedence when you have a template, text editor change, or default value. Consider the matrix below and the various scenarios presented.

Document - Add a document and enable the File field. Click Browse and locate the document on your machine, a shared drive, or within the File Cabinet, and click Open to insert the document path in the File field. Supported document types are Microsoft Word and Microsoft Excel.

Dynamic Report- Add a Dynamic Report to your Financial Package and click Search to open the Dynamic Report pane. Use the File Cabinet structure to locate the report. The selected Dynamic Report is reflected in the Dynamic Report field in the Properties pane. Print Setup selections for a Dynamic Report are applied to Financial Package reports. For example, you have a Content Type of Dynamic Report associated with a Financial Package Section when you preview or generate the Financial Package report, the print settings created for a Dynamic Report are retained in the output.

The Print Setup for Dynamic Reports is accessed by clicking Output and selecting Print Setup to open the Print Setup dialog page.

Snapshot - Select to add a snapshot to your report and click Search to open the Snapshot pane to search for snapshots. Click on the desired snapshot to update the Snapshot field in the Properties pane.

Agenda - Similar to a table of contents. The Group sections added to a Financial Package report when a PowerPoint Presentation is selected are added to a bulleted Agenda slide. To add Group sections to an Agenda slide, select the Slide Title Content Property.

Excel Add-In- Financial Package Word documents support the selection of a report generated by the Excel Add-In provided all connections are removed before adding the Excel Add-In report to the Financial Package report. The supported extension is XLSX. Financial Package PowerPoint documents support a report generated by the Excel Add-In with or without connections. Supported extensions are XLS and XLSX. Connections for the Excel Add-In report cannot be removed when saved in XLS format.

Document Type

Select Microsoft Word or PowerPoint Presentation

Supported versions of Microsoft PowerPoint are 2003 and 2010. You can upload a PowerPoint template to use when generating the output format loaded using the Template Property for the Financial Package Report. Supported versions of templates are:

• PowerPoint Presentation (*.pptx)

• PowerPoint 97-2003 Presentation (*.ppt)

Microsoft PowerPoint Specific Properties

Microsoft PowerPoint presentations are quite different from Word documents and therefore the design of PowerPoint presentation document types requires updated properties. The following sections describe the PowerPoint-specific properties and tips for using them most effectively.

Report

When PowerPoint Presentation is selected as the Document Type, the available content types are updated to support the creation of PowerPoint presentations. The supported content types for PowerPoint presentations are the following:

• Agenda

• Custom Graph

• Document – Supported formats are .xls, .xlsx, .jpg, .jpeg, .gif

• Dynamic Report

• Snapshot

• Text

Agenda

The Agenda Content Type replaces the Table of Contents (TOC) content type found in Microsoft Word Document Types. The Agenda is constructed similarly to the TOC. The Group sections added to a Financial Package report when a PowerPoint Presentation is selected are added to a bulleted Agenda slide. To add Group sections to an Agenda slide select the Slide Title Content Property. The Agenda slide can be renamed by using the Code property located under Details. Consistent with how users can update the titles of other sections, the Agenda type section can also be renamed.

Document

For the Document Content Type, Microsoft Word documents are not supported when PowerPoint Presentation is selected.

Text

Creating slides in Microsoft PowerPoint using the Text Editor in Financial Package ensures a consistent design and output environment. The following lists the supported formatting options:

• Default PowerPoint font size is 32 pt unless overridden with a template or specific selections in the text editor.

• Bold, italics, underline, font color, font family, font size selections

• The limit for the number of indents made for a single bullet is 8. Any indents that exceed 8 will be rounded to the 8th indent.

• Text that is not bulleted in the text editor will display as not bulleted in PowerPoint output.

• Different bullet formats (solid circle, hollow circle, square, for example)

Group

If Slide Title is selected, the name of the group is used as the PowerPoint slide title. Group sections are handled as Title type slides and therefore the appropriate style will be applied in the generated PowerPoint presentation. The group is added to the Agenda slide if an agenda has been added to the Financial Package report. If Slide Title is not selected then the group is not included in the output. If there is an agenda slide, the group does not appear in the agenda bulleted list.

Section

When the Slide Title is selected, the name of the content type is used as the slide title in the generated PowerPoint presentation.

For Text content type, you can use the horizontal ruler to create slide breaks in the text editor, which is reflected in the PowerPoint presentation. For example, you can create two slides with bulleted lists of information as follows:

Q1 Financial Results Analysis

• North America

• EMEA

• APAC

Q2 Forecast Preview

• North America

• EMEA

• APAC

Rather than creating two different sections with a Text content type, use the horizontal ruler to act as a slide break. So, if you created the text content type, then two slides would be created in the PowerPoint presentation. The first slide would discuss Q1 Financial Results and the second slide would discuss Q2 Forecast Preview.

Q1 Financial Results Analysis

• North America

• EMEA

• APAC

Q2 Forecast Preview

• North America

• EMEA

• APAC

If Slide Title is selected, the name of the Text Content type is used for all slides included in the text editor. You can provide different subtitles for the first line of the slide before the bulleted list as displayed above.

Generated PowerPoint Presentation

The following slide types are used when generating a PowerPoint presentation, which can be viewed by reviewing the PowerPoint Layout for the template used for presentation creation.

• Financial Package Report Slide – Title Slide

• Agenda – Title and Content

• Group – Section Header

• Section – Title and Content