ProcessAll (Method)

Applies To:

(CubeQuery)QuerySection object, OLAPQuerySection, QuerySection

Description:

Executes the Process All command for a query. If you have defined a query processing order, queries are processed in the order specified on the Query Processing Order dialog or by the ProcessSequenceNum (Property). For example, in an Interactive Reporting document file with three queries, Query4, Query2, and Query1, the queries are processed in that order.

If no query order was defined, queries are processed in the order in which they appear in the Section Catalog. For example in an Interactive Reporting document file with three queries: Query1, Query2, and Query3, the queries are processed in that order.

Syntax:

Expression.ProcessAll()

Expression Required:

An expression that returns an OLAPQuerySection or a QuerySection object

Example:

This example shows how to display the number of queries in the IInteractive Reporting document file in an Alert box, set the processing the Query section to the second position in the Query Processing Order dialog box, include the Query section in a Process All command, and then execute the Process All command for the Interactive Reporting document file:

Alert("Number of Query Sections "   +  ActiveDocument.Sections.QueryCount)
ActiveDocument.Sections["Query"].ProcessSequenceNum = 2
ActiveDocument.Sections["Query"].IncludeInProcessAll = true
ActiveDocument.ProcessAll()