Export (0) Print
Expand All

ToggleDrillState

SQL Server 2000

ToggleDrillState

Toggles the drill state of members.

Syntax

ToggleDrillState(«Set1», «Set2»[, RECURSIVE])

Remarks

This function is a combination of DrillupMember and DrilldownMember. It toggles the drill state of each member of «Set2» that is present in «Set1». If a member m of «Set2» that is present in «Set1» is drilled down (that is, has a descendant), DrillupMember(«Set1», {m}) is applied. If it is drilled up (that is, there is no descendant of m that immediately follows m), DrilldownMember(«Set1», {m}[, RECURSIVE]) is applied to Set1. The optional RECURSIVE flag is used if ToggleDrillState was called with RECURSIVE.

Example
ToggleDrillState({Product.Bread.Members},{Product.Bagels, Product.Muffins}, RECURSIVE)

See Also

DrillupMember

DrilldownMember

Show:
© 2014 Microsoft