Building Client/Server–Friendly Reports

Most of the techniques that you saw with forms apply to reports as well. As with forms, the goal is to bring over as little data as possible. The following are techniques that you can use to limit the data sent over from SQL Server when you build MDB applications:

  • Use the WhereCondition parameter of the DoCmd.OpenReport method

  • Use the Filter property of the report

  • Build the record source of a report dynamically

  • Base the report on a parameter query

  • Base the report on a view

  • Base the report on a pass-through query

  • Base the report on a stored procedure

The WhereCondition Parameter

When you use the WhereCondition parameter of the DoCmd.OpenReport method, Access includes the WHERE clause that you specify in the

Get Alison Balter's Mastering Access 2002 Enterprise Development now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial