Help For Patron Reports

Patron Reports

This help file covers the following topics:
Report Purpose HTML Report Toolbar Report Filter	Related Pages Report Formats BO Transaction Codes

1. Report Purpose

This report provides a detailed breakdown of coupons processed during the date range selected. The report detail line provides the patron card # (masked), the coupon description and ID, the value, and the transaction status.

Here's an example of a Detail Coupon Process Report.

Detail Coupon Process Report

Here's a description of the columns used in this report:

1. Unit ID	Unit ID identifies the QuickJack unit.
2. Unit Date	Unit Date is the date/time of this transaction.
3. Patron	Patron is the patron card number. (masked)
4. Coupon	Coupon description and ID number.
5. Value	Dollar value assigned to the coupon.
6. Status	Status is the current status of this transaction. (status list)

The default sort order is Unit ID | Unit Date.

2. HTML Report Toolbar

report header This toolbar provides refresh, search, export, print, page navigation etc.

1. Preview	Preview will display the report as a PDF file in the browser window.
2. Style	Select style of report. (color \| gray scale \| no fill)
3. Open All	Select "Yes" to expand and show detail lines for all collapsed sections. (with (+) sign)
4. Rpt Format	Select report format (e.g. PDF, Excel) from list, then click GO to export report in selected format.
5. Navigation	Use navigation controls to step forward or backward through report pages.
6. Parent Rpt	Return to parent report. (if currently within child report)
7. Search	Enter search string and then use find and next to step through matches. (case-insensitive)
8. Refresh	Refresh report reloading with current data.
9. + Print	Open print dialog box so that you can specify print options. (must install "print control" first!)

3. Report Filter

Here's a screenshot of the report filter screen.

Detailed Points Redeemed (Prize) Report

1. * Date Range	Select a date range to filter on (or) go with the default (gaming day).
2. + Machine	Select any machines which you would like to filter on. (see notes below)
3. + Mach Group	Select any machine groups you would like to filter on. (see notes below)
4. + Mach Location	Select any machine locations you would like to filter on. (see notes below)
5. ^ Patron	Enter last four digits of patron card number surrounded by percentage signs (%). (see above)

Submit button will generate and display a report in html format showing the HTML report toolbar.

Notes:	1. *	The default date range is based on the GamingDayStart and GamingDayEnd system parameters.
	2. *	You can enter a new date using the format yyyy/mm/dd (or) select one using the calendar tool.
	3. +	These lists are automatically populated with the machines, groups and locations for the current property.
	4. +	If no machines, groups or locations selected, the report is based on all machines for the current property.
	5. +	The Unit IDs which match the selected machines (or) groups (or) locations are included in the report.
	6. +	You can select more than one machine, group, or location within a list by using Ctrl+Click or Shift+Click.
	7. ^	The percentage sign (%) is a wildcard operator within SQL Server and represents 0 to many characters.

<< BO Online Help >>

DETAIL COUPON PROCESS

1. Report Purpose

2. HTML Report Toolbar

3. Report Filter