Administrator: Receipts Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26

Create a Report

Try it: Create a Report

Go to Create->Report Wizard.

Query: rptCustomerReceiptSQ

Select these available fields:

ReceiptID

Last Name

Name

Movie

DateRented

Description

Price

 

Group by: Last Name

Then by: Name

 

Sort by: Movie

 

Report Layout: Portrait.

Report Title: Current Rentals.

Create ->Report Wizard