• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Developing an ADP Applicatio... > Building Access Data Project Reports

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 way that you use input parameters for a form. When using input parameters, the report record source can be either a SQL statement with question marks embedded for the parameters or a stored procedure. The report called rptCustomers provides an example (see Figure 12.43).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint