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

Overdue Report

Try it: Create an Overdue Report

Go to Create->Report Wizard.

Query: rptCustomerReceiptSQ

Select these available fields:

Overdue

DateRented

Description

Price

Name

Phone

Movie

 

Group by: Overdue

 

Sort by: Name

Then by: DateRented

 

Report Layout: Landscape.

Report Title: Overdue Rentals.

 

Save this report and name it:

RptOverdueRentals.

Create ->Report Wizard