• Always check the Enable packeting checkbox on the Fetch page of the query part's settings notebook. If this is not checked, the first row of data might be pre-fetched and will be skipped when the report is formatted.

• Always check the Read-Only checkbox on the Update page of the query part's settings notebook. Checking this improves query performance and prevents possible locking problems.

• Override finalInitialize in your part to set query host variables for your primary query. Setting them via a connection from aboutToFormat might set the host variable after the query has already been run.