ControlsDropDown (Object)

Member of:

Controls collection, DashboardSection object

Description:

Represents Dashboard drop-down list objects that enable users to select data.

Example:

This example shows how to populate a dropdown list from a query limit:

// Connect to the database to ensure showvalues will work
ActiveDocument.Sections["Query"].DataModel.Connection.Username = "hyperion"
ActiveDocument.Sections["Query"].DataModel.Connection.SetPassword("Hyperion
Hyperion")
ActiveDocument.Sections["Query"].DataModel.Connection.Connect()
//Load the list of Available Values
ActiveDocument.Sections["Query"].Limits[1].RefreshAvailableValues()
var ValueCount = 
ActiveDocument.Sections["Query"].Limits[1].AvailableValues.Count

//Remove All Items from the DropDown 
DropDown.RemoveAll()
 for (I = 1; I <= ValueCount; I ++)
{
DropDown.Add(ActiveDocument.Sections["Query"].Limits[1].AvailableValues[I])
}

Method:

Add(Value As String), Item(Index As Number), OnClick(), OnClientClick(), OnClientSelection(), OnSelection(), Remove(Index As Number), RemoveAll(), Select(Index As Number)

Properties:

Read-only: ,Property Name As String, Property Type As BqShapeType

Read-write: AccessibilityText (Property), Alignment (Property) As BqHorizontalAlignmentAppendObjectText (Property), AppendObjectText (Property), Property ClientScriptStatus as Boolean, Property Count As Number, Property Enabled As Boolean, Property SelectedIndex As Number, Property Text As String, Property VerticalAlignment As BqVerticalAlignment, Property Visible As Boolean

Object:

UserValues (Collection), Font As Font