Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
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:
© 2015 Microsoft