Represents all derived items in the derived table.
All collections have a method named “Item(NameOrIndex).” This is the default method for all collections and it returns an item in the collection at a particular index or with a specific name. Use, brackets ([]) to represent calls to the Item (Method). For example, these statements cause identical behavior: myItem = Documents[1] myItem = Documents.Item(1) myItem = Documents["StartUp.bqy"] myItem = Documents.Item("StartUp.bqy") |
This example shows how to display the count of derived item in an Alert box:
Alert(ActiveDocument.Sections["Query2"].DataModel.DerivedTables["Query"].DerivedItems.Count, "Number of Derived Items")