EvDRE Parameters

When you are building an EvDRE workbook, the main EvDRE parameters you use are AppName, Key Range, and Expand Range.

Features

The primary EvDRE parameters are described below:

AppName

The first parameter accepts the default application name (taken from the current view) that is displayed next to App. In function =EvDRE($B$3,A14:B20,A23:C29), the AppName parameter is $B$3.

Example Example

In the following example, the AppName parameter points to cell B3, whose value is FINANCE.

	A	B	C
1	EvDRE:OK
2
3	App	FINANCE

End of the example.

Key range

Example Example

The second parameter uses the values in the Range/Value table. In the function =EVDRE($B$3,A14:B20,A23:C29), the Key range parameter is A14:B20.

For more information, see Key Range Parameter.

In the example, the Key range parameter points to the data in cells A14:B20.

	A	B
13	RANGE	VALUE
14	PageKeyRange	Sheet1!$B$4:$B$11
15	ColKeyRange	Sheet1!$G$3:$I$3
16	RowKeyRange	Sheet1!$E$5:$E$25
17	CellKeyRange
18	GetOnlyRange
19	FormatRange	Sheet1!$E$3
20	Options	AutoFitCol

End of the example.

Expand range

Example Example

The Expand range parameter uses the values in the Parameter/Expansion table, if you want your workbook to contain an expansion. In the function =EVDRE($B$3,A14:B20,A23:C29), the Expand range parameter is A23:C29.

For more information, see Expand Range Parameter.

In the example, the Expand range parameter points to the data in cells A23:C29.

	A	B	C
22	PARAMETER	EXPANSION1	EXPANSION2
23	ExpandIn	COL	ROW
24	Dimension	RPTCURRENCY	ACCOUNT
25	MemberSet	MEMBERS	BAS
26	BeforeRange
27	AfterRange
28	Suppress	Y	Y
29	Insert

End of the example.