•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.