Sections (Collection)

Member of:

Document object

Description:

Represents all sections in single documents.

Tip:

All collections have the “Item(NameOrIndex)” method. This is the default method for all collections that returns collection items at a particular index or by name. Use brackets ([]) to represent calls to the Item (Method). For example, these statements are identical: myItem = Documents[1] myItem = Documents.Item(1) myItem = Documents["StartUp.bqy"] myItem = Documents.Item("StartUp.bqy")

Note:

When you use the Add (method) to add a new section, note the following. It is recommended that an Interactive Reporting document file (.bqy) have no more two hundred sections to ensure smooth performance.

Example:

This example shows how to create report and query sections.

In report sections (Chart and Pivot), you must set theSection Dependency parameter. You must associate Charts and Pivots with a Query or Results set.

MySection = ActiveDocument.Sections.Add(bqChart,"Query")
or 
MySection = ActiveDocument.Sections.Add(bqPivot,"Results")
MySection.Name = "New Chart"
//Adding Queries does not require a section dependence
MySection = ActiveDocument.Sections.Add(bqQuery)

Methods:

Add(SectionType As BqSectionType, [SectionDependency as String]) As Section, ImportDataFile(FileName As String, Format As BqImportDataFileFormat), Item(Value NameOrIndex) As Section

Properties:

Read-only: Property Count As Number, Property QueryCount as Number

Objects:

Query object, Results object, Pivot object, Chart object, and Dashboard object