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: This is the only demo to create the Excel spreadsheet completely via API. Please be patient as it takes time to read huge data and the result spreadsheet is more than 1Mb!
Products by Category prints products by category. Has 3 columns per page; starts each category in new column.
Sales by Category Subreport prints 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.