Total visits per month in Pass Visit Log report
RecTrac 3.1.10.31.00
Table of Contents
Problem
I would like to have our Pass Visit Log report show the total pass visits we had per month.
Solution
You can create a custom Pass Visit Log Report from Report Output Management that breaks down totals per month.
Steps For Solution
- From the RecTrac main menu, go to Report Output Management.
- Highlight an existing custom Pass Visit Log report from the DataGrid.
- Click Update Output.
- If you do not have an existing custom Pass Visit Log report, highlight the VSI - Pass Visit Log Report from the DataGrid
- Click Run Report.
- Click Add Output.
- Give your new report output a name.
- Click Continue.
- Go to the Total Fields tab.
- Click the pencil edit icon on the Total Visit Count field.
- Filter Fields Containing to narrow results down in the Available Fields section and locate BeginDate-MonthChar (SADetail) (i.e this field will return April) or BeginDate-MonthInt (SADetail) (i.e this field will return 4).
- Drag and drop it into Total By under the Total Settings group in the Core tab.
- Set Total By Option to Total By Value.
- Set Total Option to Sum.
- Click Save to save the Total Visit Count field.
- Click Save and Exit.
You can now run this custom Pass Visit Log report to show the total pass visits per month.