Simple Set Functions

Set Function	Description
Add Blank Space	Adds a blank row or column between the results of the preceding set instructions and subsequent instructions.
Expand	Parses each element in the set so far and includes each parent elements children. The children are added below the element being processed unless a “Reverse (Subtotals at the Bottom)” set instruction is used before this instruction.
Expand All	Behaves the same as Expand except this instruction will include all descendants of the current set elements.
Expand using the Next Instruction	Expands the element next mentioned.
Enable Drill Down	Enables drill-down across the resulting set elements. The children are added below the element being processed unless a “Reverse (Subtotals at the Bottom)” set instruction is used before this instruction.
Indent prior set	Indents the result of previous instructions by one space.
Reset prior set Indents	Removes all indentation levels on previous instructions.
Remove Items using the Next Instruction	Will remove elements if they exist in the results of the previous instructions.
Remove Consolidations	Removes all elements which have child elements. This is often used with “Expand All”, “Reset prior set Indents” and the advanced instruction “Suppress Zeros” to provide a list of elements (without children) which are populated with data.
Sort by Name	Sorts the results of the previous instructions based on the element name. If an alias has been set using a instruction prior then the elements are sorted by the alias.
Format 0, 000.00	Data Number formatting
Format 0, 000.0	Data Number formatting
Format 0, 000	Data Number formatting
Format 0.000%	Data Number formatting
Format 0.00%	Data Number formatting
Format 0.0%	Data Number formatting
Format 0%	Data Number formatting
Ignore New Formatting on Prior Members	Prevents new formatting instructions from affecting the resulting elements from previous instructions.