1. Working with Financial Reporting for Oracle Enterprise Performance Management Cloud
  2. Designing Documents for Financial Reporting Books
  3. Adding Reports and Documents to Books
  4. Using Microsoft Word Documents in Books
  5. Using FRExecute to Embed Financial Reporting Reports into Microsoft Word and HTML Documents
  6. FRExecute Examples

FRExecute Examples

Example 6-1 Return the entire report with dynamic values

FRExecute(ReportName;Type=1)

Example 6-2 Return page 2 of a dynamic report

FRExecute(ReportName;Type=1ComponentType=1'ComponentName=Grid2;Page=2)

Example 6-3 Return a dynamic report with all pages

FRExecute(ReportName;Type=1;ComponentName=Grid2)

Example 6-4 Return a data cell on page 2. If you do not select the page, then return the first page's data cell.

FRExecute(reportFullName; Type=1; ComponentType=1;ComponentName=Grid2;Page=2; Cell=Cell[2,B])
FRExecute(reportFullName; Type=1; ComponentType=1;ComponentName=Grid2;Page=2; Cell=[2,B])

Example 6-5 Return a chart on page 2. If you do not select the page, then return chart 1 on all the pages.

FRExecute(reportFullName; Type=1; ComponentType=2;ComponentName=Chart1;Page=2)

Considerations

In an HTML document or Word document, "FRExecute" (including lowercase, uppercase or mixed-case letters) is the keyword of the FRExecute function. "FRExecute" cannot be used in file content or as part of the file name.

When applying a layout to a Microsoft Word text box containing FRExecute, select "Square" for Wrapping Style, and select "Left" or "Right" for Horizontal alignment.