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 Access Data Project Reports

The same guidelines that are true for forms are true for reports. The main thing to remember is that you want to bring over as little data as possible whenever possible. If you need to produce a report that contains aggregate data, you should always aggregate the data on the server. If you perform the aggregation on the client, Access will need to bring all of the necessary detail records over the network wire. On the other hand, if you use a view or stored procedure to aggregate the data, the server will aggregate the data and send only the aggregated results over the network wire.

Input Parameters

Just as a form has input parameters, so does a report. You use the input parameters for a report in the same ...

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