O'Reilly logo

Alison Balter's Mastering Access 2002 Enterprise Development by Alison Balter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required