Sample 2	using Northwind 


New Project
	Setup the Form

Add the Crystal Reports Viewer
	Anchor to full screen
Change Form Window State to Maximize


Project | Add New Item | Crystal Report
	As a Blank Report

Set Report Source of Viewer to New Report

Field Explorer
	Add Database | OLE DB Provider | Use Data Link File
	Configure using Northwind
		Add Employees, Orders, Order Details, and Products
	

	Right Click on Page Header | Insert | Picture


	Add Two Group Headers
		Employee
		Orders

	On the Detail Line
		Order ID, Product Name, Order Date, Quantity, Unit Price

	Under Group 1
		Add Two Text Objects
			Label for Notes
			Container for Notes
		Add Notes, and Photo

	Suppress the Group Name
		Right Click | Format | Common | Suppress


	Page Header
		Add a Text Object “Sales Summary:”

	
	
		Add ECC Picture
		Add a Formula Field - Full Name
			{Employees.LastName}& ", " & {Employees.FirstName}
		Add FullName to Page Header
		Format 

	Right Click on Section
		Select Group Employee Footer
		Print At Bottom of Page
		Before New Page

Group 1 Footer
	Totals for @FullName

Report Footer
	Final Totals

HighLight Label and FullName in Page Header
	Right Click - Format Multiple Objects
	Suppress and select Formula Selection
	Functions | Print State | OnLastRecord


Right Click on Group Name 1
	Change Group | Options | Customize | Use Formula
	Select FullName


Add a new formula Field
	Percentage = 
	Format | Number | Customize | Suppress if Zero
	Change Highlighting
		Value >= 20
			Font is Red

Add a new formula Field
	Sales Amount = 
{Order_Details.UnitPrice} * {Order_Details.Quantity} * (1 - {Order_Details.Discount})


Format Detail Line
	Order ID and Date

	OrderID Format “Suppress if Duplicated”


Create Running Totals
	Order Total
		Reset on change in OrderID

	Add to Order Group Footer


	Sales Total, Sales Count, Sales Average
		Evaluate SalesAmount at OrderID Change
		Reset at EmployeeID Change

	Add to Group1 Footer


Add Grand Totals and Add to Final Report Footer


Add Special Field
		Page N of M to Page Heading