The demos illustrate how to create the most diverse reports similar to those contained in Microsoft Access Northwind Sample Database using Aspose.Cells component.
A
Report is an effective way to
present your data in a printed format. You may refer it to a printed output of
the data in the database. Aspose.Cells
component gives you the agility to report your data in a variety of ways. A
report can show all or only some of the data of a record, and it can be based
on either a table or a query. The flexibility to customize reports and to
organize the data, is provided by the component.
Aspose.Cells component is fully functional for creating all types of
reports. You may customize the size and appearance of everything on a report.
You can display the information the way you want to see it. Normally, we use
The demos create 14 reports based on "Northwind.mdb" database stored in the "Database" Folder in your Application Directory. The examples also utilize a template excel file. The Northwind database contains the sales data for a fictitious company called Northwind Traders, which imports and exports specialty foods from around the world. By viewing the database objects like tables, queries and reports, you can develop ideas for your own database application. Aspose.Cells component makes use of Northwind data to demonstrate the practice session in designing queries to produce the most diverse reports, since it contains enough records to produce meaningful results. Each report is well organized, formatted and presents data in an efficient manner. Click on the different hyperlinks below, each hyperlink represents a report. You are allowed to either open the resultant reports into your browser or save directly to your disk.
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 subreport for Catalog report.
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. This is the only demo to create the Excel spreadsheet completely via API.
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 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.
Summary of Sales by Year prints summary report showing quarterly sales for each year.