FRExecute Syntax

FRExecute(ReportPath[Type={1,2};ComponentType={1,2};ComponentName={Grid1,Grid2,Chart1,Chart2,Chart3};Page={1,2,..;.}Cell=FRFormula}

where:

ReportPath is the full path to the report, including the report name.

Type1 is a dynamic report and Type2 is a Snapshot report.

ComponentType1 (optional) is a grid and ComponentType2 (optional) is a chart.

ComponenentName (optional) is the grid or chart name.

Page (optional) is the page number.

Cell (optional) is the date cell formula.

The cell syntax is cell=cell[row,col], or cell=[row,col]

where

row is a number >=1 referring to the row in Financial Reporting Studio report designer.

col is a letter >= A referring to the column in Financial Reporting Studio report designer. If a report has more then 26 columns, two letters are used for those columns (for example, AA, AB, AZ, AAA, AAB, and so on).

Note:

You can specify a "sub-tuple" if the design time row evaluates to more then one tuple. For example, if you reference row 2, which has a member selection "Children of Market" resulting in four children (East, West, South, Central), the sum of all four tuples are returned. You can also refer to individual tuples like this: Cell[2(1),A] referring to East/ColA; Cell[2(3),A] referring to South/ColA.

Note:

To limit the size of the report, place the FRExecute function inside a Microsoft Word text box.