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

Chapter 16. Working with Simple Reports ... > Creating a Grouping Report with the ...

Creating a Grouping Report with the Report Wizard

This section shows you how to use the Report Wizard to create a grouping report based on data in the Products and Suppliers tables of the Northwind Traders sample database. (Like the Form Wizard, the Report Wizard lets you create reports that contain data from more than one table without first creating a query.) This report displays the quantity of each specialty food product in inventory, grouped by product category.

Note

The process of designing an Access data projects (ADP) report is, for the most part, identical to that for conventional Access reports based on Jet 4.0 data sources. The difference is that ADP use an SQL Server table, view, function, or stored procedure as the data source for the report. ADP doesn’t support some Jet features, such as domain aggregate functions, but the workarounds for ADP limitations are relatively simple. Chapter 22, “Upsizing Jet Applications to Access Data Projects,” describes the principal workarounds required when migrating from Jet applications to ADP.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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