QueryCount (Property)

Applies To:

Section object

Description:

Identifies the count of all query sections in an IInteractive Reporting document file (.bqy). This count includes relational, OLAP and processable imported data file sections. The count does not include Data Model sections.

This property may be used on association with the IncludeInProcessAll (Property) and ProcessSequenceNum (Property) .

If you use the ProcessSequenceNumber (Property) to assign a query’s position on the Query Processing Order dialog and the value is higher than the count of query sections in the document, it is silently reset to be equal to the count assigned by the QueryCount (Property).

Action:

Read only

Example:

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

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