VSys One: Volunteer Management Software

Summary: Accounts by Quarter Reports

This report is more complex, with two column fields, two row fields and two summarized values.

There is no reason why there must be two of each, it simply makes sense for this report. You can just as easily have a report with one column fields, three row fields and two summarized fields.

1. From the VSys One home screen, select the Reports panel then click on Summary/Crosstab link.
2. When the Select saved report window opens, choose the saved or built-in report you would like to use and click Select. Or click on the Load settings link under Tools to bring up a list of options.
3. Select Account Records by Quarter.
   

Under Settings, we have the Report title, an Initial source of Account records (meaning that account records will be the basis for the report and the records we summarize will be account records), and any filters on the account records and the people who own them. To the right are the fields we're working with:

• The columns of the report will be the year and quarter of the account records. Note both of these are calculated fields.
• Rows will be the account type and account of each record.
• Summarized fields are the sum of the records and the average value of each record.

Calculated Fields

This report needed a two calculated fields to work: if we just used the record's date, we'd get insane numbers of columns. Here we're using one calculated field from the date to get the year like in the previous example and here is another calculated field to get the quarter.

You must define the calculated field before you can choose it for the report. Once it is created it will show up in your field choices with an asterisk before the name.