Click each thumbnail to open the report

Employee Sales

The one-level report shows a list of employees and their corresponding information, including their total sales.

Employee Sales with filtering (by WHERE and HAVING clause)

This report shows a list of employee information filtered by various parameters.

Employee Sales break down by Product

This report shows a list of employee information, and within each employee, it shows the list of products and total sales by that employee.

Employee Sales break down by Category then by Product with Filtering

This is a three-level report. The first level shows a list of employees. Within each employee, it shows a list of categories; this is the second level. Within each category, it shows a list of products under that category; this is the third level.

Employee Sales break down by Category and Product

This report displays a list of employee sales break down by Category and Product listed side by side.

Employee Sales break down by Category then by Product - Side by Side Comparison

This report compares the sales of two employees listed side by side.

Employee Sales break down by Category, Product, Order, and Customer

This report shows a list of employees with their corresponding information broken down by category, product, order, and customer.

Invoice

The invoice report displays an invoice.

Customer Sales filtered by period and sales amount

This report shows a list of customers filtered by the total sales amount within a certain period.

Employee Sales and Territories

This report shows a list of employee and their sales territories together with other relevant information.

Sales by Product

This report lists products and, for each product, the orders that had that product within a certain period.

Customer Addresses

The report displays a list of customer addresses sorted by country, then by region, city, postal code, and finally by company name.

Customer Address Book

The report displays a list of customer addresses sorted and grouped alphabetically.

Company List (Union)

This report combines a list of companies from the customers and suppliers using the Union operator.

Mailing List

The report displays a list of addresses in a grid to be printed as vertically-oriented address labels.

Sales break down by category, year with sales larger than a certain amount (CrossTab)

A crosstab report showing the company's sales breakdown by year and category filtered by a certain sales amount.

Sales break down by category, year and aggregate totals with filtering (CrossTab)

This is a crosstab report showing the company's sales breakdown by year, category, and aggregate total filtered by a certain sales amount.

Sales breakdown by category, product, year, quarter, with aggregate subtotal and totals (CrossTab)

A crosstab report presents the company's sales breakdown by year and category. Within each year, it shows the total sales breakdown by quarter, and within each category, it shows the total sales breakdown by product.

Sales break down by Category, Product, Customer, and Supplier (Chart)

The report presents four bar charts. The first bar chart shows the total sales by product within a specific time period. The second bar chart shows the total sales by categories within a specific time period. The third bar chart shows the total sales by customer within a specific time period. The fourth bar chart shows the total sales by supplier within a specific time period.

Employee Sales (shown in List, Chart and Cross tab)

This report shows a list of employees and each employee's sales, presented in three ways: a list, a chart, and a crosstab.

Customers who have NOT ordered a product (Semi-Join)

This report shows a list of all the customers and a list of customers who have not ordered a product.

Customer cities shared by Supplier (filtering with subquery)

This report shows a list of cities common to both the customers and the suppliers.