RowLimitActive (Property)

Applies To:

QuerySection object, DataModelSection object

Description:

Enables you to activate the query governor feature when retrieving rows against a Data Model. Use this property with RowLimit (Property) to specify the number of rows to retrieve.

Explorer and Interactive Reporting Web Client users can set a query governor, but Data Model options override those set at the query level. If row limits are set at the query level, the lower number is enforced.

Action:

Read-only, Boolean

Example:

This example enables the Row Filter setting, sets the maximum number of rows to retrieve, and processes the query:

ActiveDocument.Sections["Query2"].DataModel.RowLimitActive = true
ActiveDocument.Sections["Query2"].DataModel.RowLimit = 200
ActiveDocument.Sections["Query2"].Process()