Before Query

The BeforeQuery event occurs before the PivotTable queries its data source. Actions such as adding new fields to the PivotTable report, moving fields, and sorting and filtering data will trigger this event. Because running a complex query could take longer than expected, you may want to let the user know that a query is in progress by changing the mouse pointer to an hourglass and turning it off during the Query event (see Hands-On 24-22). There is no way to determine what type of query is going to be performed.

0 0

Post a comment