Under Advanced/Custom reports, you can find two other hours summaries which are different from the standard type. These are created as crosstabs in the Report Designer. They are not simple to customize, but are exceptionally powerful.
When to use
What groups gave you hours, broken down by month?
Steps in this task
Click on the Advanced/Custom link from the Reports panel.
Select a saved or built-in report report to use. There are three built-in reports in this class: Hours by Current Group and Month,Hours by Group and Month, and Hours volunteer crosstab by month. (When VSys stores a volunteer hours record, it remembers the group the volunteer was in at that time, and reports the hours here as being credited to that group. "Current Group" is the group each volunteer is in now, "Group" is the group they were in when their hours were credited.)
Set any filters on the volunteers or their hours.
Click Print to run the report.
Sample - Current Group and Month
Sample - Volunteer and Month
Creating your own
Using the Report Designer, you can create or modify your own hours summary grids reports.
Select a staring report. Load one of the built-in "Hours summary" variants.
Click on Design report in the lower left corner
Right-click on the "hours_: Hours_details" crosstab item in the Report Tree on the left, then select Configure.
For any of the fields on the left, "Bonus duration", "Miles", etc., drag the field to the new row, new column or new value texts. The first two of these will organize your results by those values, the last will total these values for each combination of column and row.
Click and drag away any row, column or value fields which you don't want to use.
Click on any totaled value to choose the method used, for example "Sum", "Count", etc. You can also set the font name, size and formatting for any of the values.
Click OK to close the Configure Crosstab window, then on File and Close to close the Report designer.
Experiment. It will take a few attempts to get the results you're looking for. Remember that for reports like this the Type of report must be "Hours" and that you should only have one crosstab, and no other data elements, placed on the report.
