|
Section 6 |
The Reports utility allows the user to output the data and information contained in TheGreatMultitude in various formats depending upon the user’s need including printed products, E-Mails, worksheets, or text documents. The Reports utility changes in appearance and function dependent upon the active module.
The objective of this section is acquaint the user with the various pre-formatted reports available within TheGreatMultitude and show how the different modules interact with the Reports utility to produce outputs to meet specific and general needs.
The Reports utility is accessed from
the Main Partner Screen by clicking on Reports
(Alt+R) on the main menu bar. The module
currently active will determine the screen displayed.
The Menu Bar is the uppermost bar displayed on the Reports screen. Items may be selected by either clicking on them with the mouse or by using the hot key indicated by the underlined letter of the desired menu choice.
(Alt+X) will close TheGreatMultitude after
confirming the user does want to exit the application.
(Alt+R) will return the user to the Main
Partner Screen.
(Alt+L) will open the Search/Lookup utility.
(Alt+O) will open the Tools utility.
(Alt+P) will open the Bug Report window.
(Alt+H) or the F1 function key will open the
Help window.
The Vertical Toolbar is located along the left side of the Reports Screen and shows icons representing the various modules that can be activated. Changing a module will change the content of the of the Reports Screen.
Figure 6-2 Reports Vertical Toolbar
Clicking on the Partner Reports Module icon
on the Vertical
Toolbar accesses the Partner Reports Module. Once the Partner Reports Module is
activated, the body of the Reports Screen will show the functions and options available
with this module.
On the left side of the main viewing area is a list of the various reports that are available within this module.
Figure 6-4 Partner Reports Selection List
Below this table is a brief description of what the highlighted report will show
To select a particular report, the user should click on the desired report in the table.
Address/Phone Listing: Lists names, addresses, phone numbers Partner ID, Type of Partner, and Donor Level of selected Partners, in portrait orientation.
On the right of the main viewing area, the user is offered various options for customizing this report to meet their particular needs.
Figure 6-5 Partner Address Report Options
Selecting “All Records” to include in this report will include all Partners.
Selecting “Single Partner Only” to include in this report will print data for only one Partner. The Partner ID for the desired Partner must be entered into the “Enter Partner ID Here:” text box.
Data will not be printed for a Partner with the “No Mail” box checked on their Main Partner Screen.
Selecting “Records matching the last Search/Lookup, sorted by order shown in Search/Lookup.” to include in this report will print data for all of the Partners of the last Search/Lookup in the last order shown in Search/Lookup. This is one method to sort Partners by State, City, Zip/Postal Code or other search fields.
Selecting “Records matching the selected criteria” enables
the user to print out data selectively based upon the desired criteria. To
establish the desired criteria, the user must click on the “selected criteria” link.
This will open the Selected Report Criteria window.
Figure 6-5.1 Select Report
Criteria
The user can then select the Search Group to use to identify certain
sets of Partners. These are the Search Groups defined by the user in the Tools Utility and
appear on the individual Partners Main Partner Screen when the Partners Module
is Active. To use a particular Search Group, or multiple Search Groups, the
user must click on the check box next to the desired Search Group.
The user can elect to include or exclude the Selected Groups by
selecting from the drop-down menu. Include means that only the data from those
Partners with any of the checked search groups checked on their Main Partner
Screen will be printed. Exclude means
that all Partners not having any of the checked search groups checked on their
Main Partner Screen will be printed.
For example, if the user wants a listing of anyone of his partners who
speak Spanish, he would check Spanish Speaker and Spanish Only. This will produce a listing of any Partners
who are listed as Spanish Speakers or as Spanish Only. If he were just looking for a translator, he
would only check Spanish Speaker. If he
were sending out a letter that was only in English, he would check Spanish Only
and select Exclude checked groups.
Donor Level can
also be used as a criteria by selecting the Donor Level from the drop-down
menu. Only data for those partners
meeting the selected Donor Level and any selected search group criteria will be
printed.
Selecting the Reset to Default Values button
will de-select all of the checked groups and
reset Donor Levels to All Levels. Once the user has
set the criteria that he wishes for TheGreatMultitude to use, he may select the
Accept
,
or Cancel button
as appropriate.
The “No Mail” Option allows the user to override the “No
Mail” restriction by clicking on the check box labeled “Include Partners that
have “No Mail” checked.
The “Church Directory Version:” will only print out the Chur/Min/Bus name,
title, name, spouse’s first name, Address and phone numbers.
To preview the report prior to printing, the user should
click on the View Report button
.
Figure 6-6 Partner Address and Phone Listing Output
The header and footer give the user the option to either close the window or print the report. The user should select one of these options. The header will also show how many records are included in this report. Neither the header nor the footer will appear on any of the printed reports.
Mailing Labels: Will print the names and addresses of selected Partners on standard mailing or shipping labels.
Figure 6-7 Selection – Mailing Labels
The options for Mailing Labels are the same as above with the option to pick label size replacing the Church Directory Version option.. The user must choose the Mailing (Avery 5160) or Shipping (Avery 5164) label. Labels will be sorted by Zip/Postal Code unless Records matching the last Search/Lookup is selected.
The Avery 5160 is a standard 3 up, 30 per sheet, 1” x 2-5/8” mailing label.
The Avery 5164 is a standard 2 up, 6 per sheet, 3-1/3” x 4” shipping label.
At the top of each Label view is a small interactive graphic that allows the user to select exactly which label position to begin printing. This is useful when the first sheet of blank labels is not a full sheet.
The header and footer give the user the option to either close the window or print the report. The user should select one of these options. The header will also show how many records are included in this report and the number of sheets to be printed to aid the user in setting up their printer Neither the header or the footer will appear on any of the printed reports.
Datasheets: Will print a complete listing of the Partner’s Information available on the Main Partner Screen in the Partner Module. Specifically, it will print Name, Partner ID and Type, Donor Level, all Personal Information, Birthdays and Anniversary, Children’s Information, Addresses, Phone Numbers, E-Mails and Web Site, and any comments entered. This printed in Portrait orientation, one Partner per page.
Figure 6-11 Selection Table – Datasheets
The options for Datasheets are the same as for Address/Phone Listing without the Church Directory Version option.
Partner Letters: Will allow the user to print a personalized letter to selected Partners.
Figure 6-13 Selection – Partner Letters
The options for Partner Letters are the same as for Address/Phone Listing except as shown below.
The Church Directory Version option is not available.
The date of letter may be typed in to
the text box or entered using the Calendar icon
. This is the date that will be printed on each
letter.
Figure 6-14 Partner Letter Option Area
The body of the letter should be typed directly into the Main Text box. The sample text must be deleted first. The quickest method to do this is for the user to click the mouse pointer in the middle of the text box. Then press Ctrl-A, this will select all of the text, then begin typing the content of the letter. The closing line (i.e. Yours Truly,) also goes into the Main Text box.
The Footer/Postscript Text box works the same as the Main Text box and should include the writer’s name and/or organization as well as any postscripts.
At the bottom is a link that will allow the user to save the letter just typed as a default. This will allow the user to avoid typing in the same letter again if the same or a similar letter is sent out periodically.
To view the letter prior to printing,
the user should click on the View Letters button
. This will
show all of the letters to be printed not just a sample.
Figure 6-15 View Partner Letter
To save time and effort, simply click on
the PADS button 
and let 5 Minute Photo take care of printing
and mailing your Partner Letters.
To print the letters, the user should
click on the Open in MS Word button
,
then either click on the Print icon
from the MS Word toolbar or use the File –
Print menu option. Closing Word will return the user to TheGreatMultitude. While the letters can be printed from View
Letters, this is not recommended at this time as the printout will show web
information on the top and bottom of the letters. The formatting necessary to allow for this
will be available in the near future.
To print out matching labels after
printing the Partner Letters, select Mailing Labels
in the Select a Report list and then enter the same selection criteria as used
for the Partner letters.
If the user desires to utilize the
Print And Deliver Service (PADS), the user should click on
the PADS button.
Broadcast E-Mail:Will allow the user to send a personalized E-Mail to selected Partners with valid E-Mail addresses.
Figure 6-16 Selection – Broadcast E-Mails
The options for Broadcast E-Mail are the same as for Address/Phone Listing without the Church Directory Version option
Selecting the Continue button
will open the E-Mail Distribution window.
Figure 6-17 E-Mail Distribution
Window
The E-Mail Distribution window will show a listing of all of the Partners with E-Mail addresses. The “No Mail” check box on the Main Partner Screen does not affect this listing. The user should check the boxes adjacent to the Partners that are to receive the E-Mail. Alternately, the user may click on the Select all Partners box and then deselect the Partners who are not to receive the E-Mail. Note that some Partners may have multiple addresses and the user may need to only check one of those available.
Clicking on the Close Window button
will cancel the process and return the user to
the Partner Reports Screen.
Clicking on the Next Step button
will open the Send Mail To Partners page.
The user should select either Text or HTML for the body format. Unless the user is familiar with HTML, they should select text.
The user should check the box for Include personalized "Dear <Salutation>," as first line in e-mail if the user wants the e-mails to have the salutation.
The user should replace the sample text in the Subject line and Body in the same fashion as for the Partner Letters.
At the bottom of the Send Mail To Partners page is a link that will allow the user to save the E-Mail just typed as the default. This will allow the user to avoid typing in the same E-Mail again if the same or a similar E-Mail is to be sent out.
The E-Mails are sent when the user
clicks on the Send button
. This will send the E-Mails and return the
user to the Partner Reports Screen. The
from block of the e-mails sent will be the e-mail address used to open
TheGreatMultitude.
When the E-Mail is sent, the E-Mail Distribution window will open confirming that the E-Mails have been sent.
Figure 6-20 E-Mail Confirmation
When the Close Window button
is selected, the
E-Mail Distribution window is closed and the user is returned
to the Partner Reports Screen.
If the user does not want to send the
E-Mail, he should click on the Cancel button
. This will not send the E-Mails but does
return the user to the Partner Reports Screen.
Custom Reporting Tool: This feature will be discussed completely in the Section 7.
Clicking on the Contribution Reports
Module icon
on the Vertical
Toolbar accesses the Contribution Reports Module. Once the Contribution Reports
Module is activated, the body of the Reports Screen will show the functions and options available
with this module.
On the left side of the main viewing area is a list of the various reports that are available within this module.
Figure 6-22 Contributions Reports Selection List
Below this table is a brief description of what the highlighted report will show
To select a particular report the user should click on the desired report in the table.
Detail Contribution Report: Lists the Partner ID, Name, Partner type, Donor Level, Gift Amount, Product Amount, Total Amount. Gift Date, Deposit Number, General Ledger Account # and Letter code for all contributions made within a set period of time.
The user defines the date range for the report by
typing the desired beginning and ending dates into the appropriate text boxes or
selecting them after clicking on the Calendar icon. When
typing directly into these date blocks the user must use the format mm/dd/yyyy
or an error message will appear.
Figure 6-23 Contribution Report Options
Leaving the Beginning and Ending dates both blank will show all contributions. Leaving the Beginning Date blank will show all contributions made prior to the Ending Date. Leaving the Ending Date blank will show all contributions made after the Beginning Date.
The report can be Grouped and Sub-Totaled by the user selecting any of the criteria available in the drop down menu.
Grouping and Sub-Totaling by Deposit Number is a good way to assist in reconciling bank deposits.
The user must have MicrosoftÒ Excel installed on their computer to open the report in MS Excel for additional editing, to print the report or to save it to their local drive
The user can choose to view and print
the report by clicking in the View Report button
,
or to make adjustments to the report by clicking on the Open in MS Excel button
. This
report should be printed in Landscape orientation.
To print matching labels for those Partners
matching the above set criteria, the user must click on the Print Matching
Labels button
. This will print labels for the Avery 5160
labels.
Figure 6-25 Detail Contribution Report
Contribution Letters: Will enable the user to print a personalized contribution letter listing the contributions made over a fixed period of time to all Partners with contributions listed within those time constraints. This is also the best choice for printing tax receipts.
Figure 6-26 Selection – Contribution Letters
On the right of the main viewing area, the user is offered various options for customizing this report to meet their particular needs.
Figure 6-27 Contribution Letters Options
The Beginning and Ending Date options function the same as for Detail Contribution Report.
Date of Letter is the date that will be printed on the letter.
Three text boxes are provided for the user to enter text. These function the same as for the Partner Letters.
At the bottom is a link that will allow the user to save the letter just typed in as the default. This will allow the user to avoid typing in the same letter again if the same or a similar letter is sent out periodically.
To print the contribution