Embedding Named Range from a Reference File to a Doclet

An Excel based Reference file with report content created in Microsoft Office Excel, can be embedded at the end of a Word based doclet or in the case of embedding in PowerPoint doclets, an additional slide is created at the end of the Power Point doclet and the embedded content is placed in it. In Oracle Smart View for Office, you can insert content in a specific position in the doclet. For more information, see Setting Up Narrative Reporting in Smart View.

To embed report content from a Reference file to your doclet:

1. Select the doclet that you would like to embed content into from a Reference file and check out the doclet from the report center.
2. Select the next to the doclet and then Act on Content and select Inspect Embedded Content
3. Select the Report Contents tab.
4. Select from the Embedded Content tab to add embedded content to a doclet from a Reference file.
5. An Embed Available Content dialog is displayed with a list of named ranges that you can add from the associated Microsoft Office Excel file.

   Note:

   The Embedded Content tab displays all available ranges from Reference doclets and any available Reference files attached to the doclet.
6. Optional: An author can choose to add a new range. This can be done by making available an existing named range in a Reference file or by adding a new Reference file. From the Embed Available Content dialog, select New Report Content at the bottom of the dialog as shown in this image below.
   
   
7. Optional: Select an existing Reference file or another by selecting Local File to choose a new Reference file. After you select a source, the named ranges are displayed as Source Objects.
8. Select the check box for an available named range as shown in the image below to add to the Report Contents tab. Update or enter a new Display Name and optional Description.
   
   
9. Select OK. The named range is added to the end of the Word doclet in Narrative Reporting or in a new slide at the end of a Power Point presentation.
10. Optional: From the Embedded Content tab dialog you can delete embedded named ranges. Select to the right of the embedded named range and select .

    Note:

    When an embedded content reference is deleted from a doclet, only the link is removed. The actual report content is kept intact within the doclet. However, the report content is no longer refreshable. The doclet author can now modify or delete the report content within the doclet.
11. Select Close.
12. Select Act on Content and select Check In .