The Access Ticket Attendance report allows you to report on attendance figures for Access Control events.
RecTrac Process and Reporting screens offer numerous fields and widgets that allow you to filter the data for which your process or report is being run. RecTrac Widgets provides definitions and examples to show you how these work.
Buttons on the screen…
Access Ticket Reports
Access Ticket Template Datagrid (SAAccessTicketInfo_RecordCode_DataGrid)
The Access Ticket Template DataGrid displays all access ticket templates in your database based on the DataGrid filters being used and your Permissions.
Highlight/select individual records from the DataGrid. Multiple selection is allowed.
OR
Select the Use Access Ticket Template Range option.
THEN
Input the range of access ticket templates you wish to include.
Make selections in the DataGrid or use an access ticket template range or both. Leaving the DataGrid blank and the Use Range option deselected will result in no access ticket codes being selected.
Click here for a full description of RecTrac DataGrids.
DeleteUse Access Ticket Template Range (SAAccessTicketInfo_RecordCode_UseRange)
Select this option to include only those access ticket templates in the begin and end access ticket code range in your output, as well as any selected in the DataGrid, if applicable.
THEN
Input the range of access ticket templates you wish to include.
Make selections in the DataGrid or use an access ticket template range or both. Leaving the DataGrid blank and this option deselected will result in no access ticket templates being selected.
DeleteBegin Access Ticket Template (SAAccessTicketInfo_RecordCode_Begin)
If opting to Use Access Ticket Template Range, enter the beginning and ending range of access ticket templates you want to include on your output.
DeleteEnd Access Ticket Template (SAAccessTicketInfo_RecordCode_End)
If opting to Use Access Ticket Template Range, enter the beginning and ending range of access ticket templates you want to include on your output.
DeleteAccess Ticket Template Wildcard (SAAccessTicketInfo_RecordCode_Equals)
If opting to Use Access Ticket Template Range, then select a single item to use as a base for your wildcard selection.
OR
Enter a wildcard value, if desired
THEN
Select a Wildcard Option. Depending on your selection, wildcard asterisks/periods may be required.
WildCard Option (SAAccessTicketInfo_RecordCode_Equals_Option)
Select your Wildcard Option for this process:
- Equals - The process will return a list of all records that equal the value entered. This must be an exact match. For Example: If this was a list of Family Members, entering 'Grace Somersby' would find 'Grace Somersby' because it is an exact match, but it would NOT find 'Grace J. Somersby' because it is not an exact match.
Note: When running Reports you can use a comma-delimited list (with no spaces) in the corresponding Wildcard field when your Wildcard Option is Equals. This applies to Reports only. For Example: Entering "48116 5851 88003" in a Zip Code Wildcard field on a Report and using the Equals Option would yield results from those three separate Zip Codes.
- Begins - The process will return a list of all records that begin with the value entered. Wildcarding asterisks/periods are not needed. For Example: If this was a list of Family Members entering 'Gr' would find all members whose name begins with 'Gr' such as Grace Somersby but it would NOT find Ginny Weasley because her name begins with 'Gi.'
- Ends - The process will return a list of all records that end with the value entered. Wildcarding asterisks/periods are not needed. For Example: If this was a list of Family Members entering 'by' would find all members whose name ends with 'by' such as Grace Somersby but it would NOT find Sam McGee because his name ends with 'ee.'
- Matches - The process will return a list of all records where a value match can be found. Wildcarding and asterisks/periods must be used. For Example: If this was a list of Family Members entering '*om*' (asterisks must be included) would find Grace Somersby and Tom Sawyer because "om" appears in both names but it would NOT find Felicity Lemon because "om" does not appear anywhere in her name.
Note: See also: RecTrac Wildcarding.
Record Status (SAAccessTicketReport_RecordStatus_ComboBox)
This field is hidden on the default Vermont Systems design.
DeleteAccess Ticket Fully Used? (SAAccessTicket_FullyUsed_Combobox)
Select your fully used option for the report. Multiple selection is allowed.
OR
Leave this field at (0) Selected to skip this filter.
- Yes - Include access tickets that have been fully used.
- No - Include access tickets that have not been fully used.
Module (SAAccessTicket_Module_Combobox)
Select the module(s) you want to include on your report. Multiple selection is allowed.
OR
Leave this field at (0) Selected to skip this filter.
Use Item Code Range (SAAccessTicket_ItemCode_UseRange)
Select this option to include only those item codes in the begin and end item code range in your output.
THEN
Input the range of item codes you wish to include. These are the items to which your access ticket templates are linked.
Begin Item Code (SAAccessTicket_ItemCode_Begin)
If opting to Use Item Code Range, enter the beginning and ending range. These are the items to which your access ticket templates are linked.
DeleteEnd Item Code (SAAccessTicket_ItemCode_End)
If opting to Use Item Code Range, enter the beginning and ending range. These are the items to which your access ticket templates are linked.
DeleteItem Code Wildcard (SAAccessTicket_ItemCode_Equals)
If opting to Use Item Code Range, then enter all or part of an item code to use as a base for your wildcard selection.
OR
Enter a wildcard value, if desired
THEN
Select a Wildcard Option. Depending on your selection, wildcard asterisks/periods may be required.
WildCard Option (SAAccessTicket_ItemCode_Equals_Option)
Select your Wildcard Option for this process:
- Equals - The process will return a list of all records that equal the value entered. This must be an exact match. For Example: If this was a list of Family Members, entering 'Grace Somersby' would find 'Grace Somersby' because it is an exact match, but it would NOT find 'Grace J. Somersby' because it is not an exact match.
Note: When running Reports you can use a comma-delimited list (with no spaces) in the corresponding Wildcard field when your Wildcard Option is Equals. This applies to Reports only. For Example: Entering "48116 5851 88003" in a Zip Code Wildcard field on a Report and using the Equals Option would yield results from those three separate Zip Codes.
- Begins - The process will return a list of all records that begin with the value entered. Wildcarding asterisks/periods are not needed. For Example: If this was a list of Family Members entering 'Gr' would find all members whose name begins with 'Gr' such as Grace Somersby but it would NOT find Ginny Weasley because her name begins with 'Gi.'
- Ends - The process will return a list of all records that end with the value entered. Wildcarding asterisks/periods are not needed. For Example: If this was a list of Family Members entering 'by' would find all members whose name ends with 'by' such as Grace Somersby but it would NOT find Sam McGee because his name ends with 'ee.'
- Matches - The process will return a list of all records where a value match can be found. Wildcarding and asterisks/periods must be used. For Example: If this was a list of Family Members entering '*om*' (asterisks must be included) would find Grace Somersby and Tom Sawyer because "om" appears in both names but it would NOT find Felicity Lemon because "om" does not appear anywhere in her name.
Note: See also: RecTrac Wildcarding.
Use Item Original Transaction Date Range (SADetail_TransactionDate_UseRange)
Select this option to filter the report output by transaction date range (the date on which the transaction was processed), if desired.
THEN
Select your date range.
OR
Leave this option deselected to skip this filter.
Begin Transaction Date (SADetail_TransactionDate_Begin)
This field is applicable only if you opt to Use Transaction Date Range.
Select your transaction options for this report.
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select. Transactions processed in your database within the date range selected will be included in your output.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteEnd Transaction Date (SADetail_TransactionDate_End)
This field is applicable only if you opt to Use Transaction Date Range.
Select your transaction options for this report.
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select. Transactions processed in your database within the date range selected will be included in your output.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteUse Date Used Range (SAAccessTicket_DateUsed_UseRange)
Select this option to filter the report output by used date range (the date on which the ticket was used/scanned), if desired.
THEN
Select your date range.
OR
Leave this option deselected to skip this filter.
Used Date Begin (SAAccessTicket_DateUsed_Begin)
This field is applicable only if you opt to Use Date Used Range.
Select your use date options for this report.
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select. Access tickets used/scanned in your database within the date range selected will be included in your output.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteUsed Date End (SAAccessTicket_DateUsed_End)
This field is applicable only if you opt to Use Date Used Range.
Select your use date options for this report.
THEN
Take appropriate action in the right-hand column to specify the actual date you wish to select. Access tickets used/scanned in your database within the date range selected will be included in your output.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
Delete