What to check
A slow preview can reflect an expensive query, report processing, or output configuration. Compare repeat runs and a known working layout under similar conditions. Keep the same parameters so timing differences mean something.
Troubleshooting steps
- Measure the time for the query to return the required data using an authorized read-only diagnostic connection.
- Inspect selected columns, filters, joins, and subreports. Reduce unnecessary data before adding report-side formulas or formatting changes.
- Compare preview and export, reviewing printer dependencies and the runtime environment if data retrieval is already fast.
Confirm the result
Retest with representative data and confirm that totals and row counts remain correct. A faster report is useful only when it preserves the intended business result.