Using the Xtreme sample database that ships with Crystal Reports, create a report that invoices customers for each order. This report needs to show the customer billing address, the PO#, the sales person, the order date, the requested date, the ship date and the company that shipped the order. The Details section should list the product ID, the product name, the description, the unit price, the quantity and the line item total.

 Select only those orders with an Order Amount greater than zero and with a ship date between January 1, 2004 and March 31, 2004. Group on the Customer ID, then on the Order ID. Display each order on its own page. Sum the line item total amount for each Order ID. Calculate the sales tax for the order at 6% and total the subtotal and sales tax.

You will need to pull data from the following tables :
Customer Orders Orders Detail Product Product Type Employee
You will need to create the following formulas:
Line Item Total that multiplies the unit price by the quantity for each product ordered Sales tax that multiplies the sum of each line item total by 6% Order Total that adds the sum of each line item total and the sales tax Product Description that contains nested  If…then…else…. statements to show the Size field if the Color field is empty, the Color field if the Size field is empty, and both fields, separated by a comma, if both contain data
You will need to create the following text boxes:
An address box with the text To: followed by the company name, the address, city, region and postal code An employee box with the employee’s first name, a space, and the last name
Format the report to look like the illustrations on the following pages:
Invoice _____________________ Date: December 27, 2005 Invoice Number: 1143

$14.85
$899.85
$2,939.85