These demos illustrate to create all the reports similar to those contained in Microsoft Access Northwind Database Sample.
Alphabetical List of Products prints products grouped by first letter of name.
Catalog Prints a catalog of products. Has two-page report header; uses photos for each category; starts each category on a new page; keeps all records for a category on same page; prints an order form in the report footer on a separate page.
Catalog Subreport prints products grouped by first letter of name.
Customer Labels prints customers' company names and addresses on 3-up labels.
Employee Sales by Country prints sales grouped by country and employee. Calculates subtotals, grand total, percents; prints range on report; prints message when employee's total reaches goal; a sheet per country.
Invoice prints each invoice on a separate page. Note: We generate invoices for the first 100 orders for demo only as it takes much time to read huge data and the result pdf report is nearly 5.7Mb for the total 831 invoices!
Products by Category prints products by category. Has 3 columns per page; starts each category in new column.
Sales by Category prints sales for 1994 by category. Shows sales in a subreport and in a chart on the main report.
Sales by Category Subreportprints subreport for Sales by Category report.
Sales by Year prints quarter totals in subreport in group header; optionally prints detail records. Displays page header on pages that don't have a group header.
Sales by Year Subreport prints subreport for Sales by Year report.
Sales Totals by Amount prints sales in descending order by amount. Prints top 10 customers on first page; prints page total in page footer.
Summary of Sales by Quarter prints summary report showing sales from multiple years for each quarter.
Summary of Sales by Year prints summary report showing quarterly sales for each year.