Tips for optimizing report and subreport performance

There are several things you can do to make your reports print faster. In addition to the tips listed below, you can use the Performance Analyzer to analyze specific reports in your database. For information on using the Performance Analyzer, click .

Performance tips

• Avoid overlapping controls.
  
  
• Use bitmaps and other graphic objects sparingly.
  
  
• Convert unbound object frames that display graphics to image controls.
  
  
• Use black-and-white rather than color bitmaps.
  
  
• Avoid sorting and grouping on expressions.
  
  
• Index fields you sort or group on.
  
  
• Base subreports on queries rather than tables, and include only fields from the record source that are absolutely necessary. Extra fields can decrease subreport performance.
  
  
• Index all the fields in the subreport that are linked to the main report.
  
  
• Index any subreport fields used for criteria.
  
  
• Avoid using domain aggregate functions. Include the field in the report's underlying query or use a subreport.
  
  
• Make sure the report's underlying query is optimized.
  
  
• Use the HasData property or NoData event to determine if a report is bound to an empty recordset.