Previous Topic

Next Topic

Book Contents

Book Index

Hours Summaries Grids Reports

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

Steps in this task

  1. Click on the Advanced/Custom link from the Reports panel.

    Linked Graphic

  2. 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.)
  3. Set any filters on the volunteers or their hours.
  4. Click Print to run the report.

Sample - Current Group and Month

Linked Graphic

Sample - Volunteer and Month

Linked Graphic

Creating your own

Using the Report Designer, you can create or modify your own hours summary grids reports.

  1. Select a staring report. Load one of the built-in "Hours summary" variants.
  2. Click on Design report in the lower left corner
  3. Right-click on the "hours_: Hours_details" crosstab item in the Report Tree on the left, then select Configure.
    Linked Graphic
  4. 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.
  5. Click and drag away any row, column or value fields which you don't want to use.
  6. 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.
  7. Click OK to close the Configure Crosstab window, then on File and Close to close the Report designer.
  8. 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.

See Also

Reports

Report Concepts

Account Records

Assignment Calendars

Assignment Calendars (RTF)

Assignments Listings Reports

Awards Reports

Comments Reports

Configuration Reports

Demographics Reports

Expiring Certifications Reports

Hours Reports

Hours Summaries Reports

Interview Reports

Invalid Addresses Reports

Job Associations Reports

Job Definition Reports

Mandates

Memberships

Others

People Reports

Phone Lists Report

Profiles Report

Program Statistics Report

Recurring Assignments Report

Relationships Report

Security Reports

Sign-in Lists Report

Slot Details

Slot Summaries Report

Summary/Crosstab Reports

Survey Details Report

Survey Summaries Report

Training Reports

Who's Checked In Report

Who's Late/No-show Report

Advanced Reporting Tools

Custom Column Reports

Advanced/Custom Reports