Narrative View in Oracle On Demand

Here is a post about Narrative View's in Oracle On Demand. Thanks to my good friend and colleague Asmita for sharing this.

  

Narrative view allows report users to display multiple reports or virtually any HTML content.

Narrative view is used to create letters, quotes, or invoices.

Using Narrative view we can embed other reports, web pages, or any HTML document.

Step 1: Select the appropriate Subject Area and add the columns/data you want to display in the report

Step 2: Code a HTML file as per required format. To embed report columns in to HTML add ‘@’ followed by column number.  

E.g. @1 – Society Name

Note: Count Columns from left to right.

Step 3: Add a Narrative view to your report by clicking the Add View button, moving to the advanced submenu, and selecting the Narrative option.

Step 4:  

-The Edit View: Narrative window contains five fields

- Add HTML file syntax created in Step 2 in Narrative field

- Save and Run

Useful tips:

·         Alignment sometimes gets confused, set it at the narrative format level to left.

·         Sometime you need to edit the HTML, for sizing, row breaks.

·         Keep it simple to start with.

·         Use tables for layout where you can.

·         You can insert images but they must be accessible to all users.

·         Use the narrative object to integrate external websites for information.

·         Add a web link to launch the report specifically for a contact/account etc. e.g. the change of address.

·         Narrative reports need the scripting privilege on your role to access.

Cheers!