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

Chapter 11. Developing an MDB Client/Ser... > Building Client/Server–Friendly Repo...

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


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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