Reports

Choose Report Type

You get to the Choose Report Type dialogue
by clicking on the File menu and then selecting the New menu item.
Alternatively, you can just press the New toolbar icon.

You use this dialogue to
generate reports from the database. As you chose a report from the
list, the setup tab changes accordingly. Click on the setup tab to
make any required adjustments to how the report gets generated. The
setup information for each type of report gets stored for the next
time the report is chosen. The only exception to this is when
using custom reports.

When you have chosen the type
of report you want to generate, and have confirmed the setup
options, press OK to generate the report. You can then save the
report or print it out. Reports that you save can be reloaded at a
later date.

Under the File menu is also an
option to export the report into a tab-delimited text file.
Such a file can be easily loaded into other applications, such as
Microsoft Excel. It can also be exported as a HTML file which
will retain more formatting features like the font size, style and
colour. All the reports can also be exported to Microsoft
Word document format. Word 97 or higher must be installed on your
computer for this exporting option to be available. Click on
the link to read the information about exporting to Microsoft Word.

You can also set the type of
fonts that you want to use for the reports.
You can learn more about that lower down in this help topic or by
clicking on the screenshot above. To save your font changes, you
must press the OK button. Any other reports currently
open will get updated to use the new fonts. These font
settings are also available of the preferences dialogue. The
font settings have no effect on generated custom reports as those
type of reports specify their own fonts (apart from the header and
footer).

Public Talks uses a
multi-document interface so this means than you can have more than
one report open at the same time.

There is a separate help topic for each setup page.
What follows is a brief description of each report and what type of
report it generates. Click on the relevant links to jump down to
the summary of the report in question:

Custom reports are very
powerful because they are based upon a script file (which you
create). This means that it is entirely up to you as to what
is in these reports and how they look. They can even include
information from tables and fields that you might have added into
the database.

Several sample scripts are
supplied with the program. Manage your scripts using the
custom reports maintenance
page.

Once you have selected the
custom report option, you must then click on the setup tab
and choose a custom report to use.

The font settings described
below have no effect on custom reports since these reports specify
their own fonts. However they DO still apply to the header
and footer of the document. Click on the link above for more
details.

The Away Talks report produces a list of
talks that you have assigned to be given away at other
congregations. You can specify by date range which talk assignments
you want to include.

The following information is generated
for each away talk:

Brother

Talk number

Talk date

Congregation

Time of meeting

This report has been designed so that you
can give a copy of the report to each brother that gives public
talks away at other Kingdom Halls. This way, all brothers will know
who is going away, when and where.

There is also an option to generate away
talk slips. Instead of producing a tabulated list as just
described, it generates special slips which you can give to each
brother.

The Congregations List report produces a
list of congregations that you have in the database. You can choose
how the report is sorted.

The following information is generated
for each congregation:

Congregation

Last date invited

Meeting Time

Coordinator

This report has been designed so that you
can determine which congregation you would like to exchange
speakers with next.

There are two other report modes to generate
different reports. One mode allows you to list
which speakers give particular talk numbers. The other report
mode lists the speakers and their talk numbers for one or more
congregation(s). Further options allow you to indicate which
of the speakers and their talks haven't been heard within a certain
number of months. This latter mode will also show any
associated notes for each speaker or congregation.

The Home Talks report produces a schedule of
talks assigned to be heard at your Kingdom Hall. Options can be
setup to additionally include a summary of the away talk
information aswell. The away talk information can be generated with
a different text colour so that it stands out from the home talks
information. You can specify by date range which talk assignments
you want to include.

The following information is generated
for each home talk:

Talk date

Visiting speaker

Visiting congregation

Theme of talk

Chairman

Interpreter

Hospitality

Watchtower Conductor

Watchtower reader

If you opted to include away talk
information, then the following is additonally
included:

Away speaker

Talk number

Congregation

Time of meeting

If you do include away talk information
in the report, then you must set your paper size to A4 landscape
when printing otherwise all the information will not fit onto the
page.

This report has primarily been designed for
you to produce a schedule to be placed on the notice board at your
Kingdom Hall.

You can personalise this report by
specifying what you want for the title and all the column
headings.

The Hospitality List report generates a list
of speakers visiting your Kingdom Hall and who is assigned to offer
them hospitality. If you haven't specified this information, the
column will be left blank for you to write in the name of
a brother or sister who will be having this visiting brother back
for some hospitality. You can specify by date range which talk
assignments you want to include.

The following information is generated
for each visiting speaker:

Speaker

Congregation

Talk date

Brother offering hospitality
(optional)

This report has been designed so that you
can give the printout to the brother who handles the hospitality.
He can then arrange who will be giving hospitality and write their
names in the blank spaces provided. However, if you handle
this assignment yourself, you can enter the names via the
maintenance pages.

The Talks Annual Review report lists in
tabular format the public talks given in selected years. Options
specify the amount of detail included for each talk.

As illustrated above, the report lists the
following information for the range of public talks selected:

Talk number

Theme of talk

And then for each year selected:

Month in which the talk was delivered

Day within
the month (optional)

Number of
occasions the talk was heard in the year (optional)

Names of
speaker and his congregation (optional)

This
report corresponds in purpose, style and content with theS-99form entitled “Public Meeting Talk Titles” and issued
by your local Branch Office. It will help you to identify at a
glance those talks, which your congregation has heard less
frequently than some others. Please understand that this
reportis not intended to
replacethe formS-99.

You may export this report in two formats,
namely, HTML and DIF. You may subsequently manipulate these reports
thus:

The Talks By Category report produces a list
of all public talks on a category by category basis. Options
determine how the public talks are sorted under each category
heading.

This report has been designed to enable you
to more easily identify the public talk outlines that fall into a
particular category. The categories are provided by the society and
this report is based upon form S-99a.

The Talks Summary report produces a summary
of both home and away talks for yhe specified dates.

The report has been designed for three main
reasons:

Produces a summary of all the talks for a
given year (good for keeping records up-to-date).

You can select specific dates identifying
your exchange with a particular congregation and send this report
to them as confirmation of the exchange details.

You can select dates in the future which
have not yet been assigned. Such entries will show as a blank
entry. This allows you to write in the new details (perhaps
whilst on the phone) and then add them into the program
later. This feature is also useful for planning the whole
year, since you will have all the dates worked out for you
automatically.

This report doesn't include the themes, just
the talk numbers, hence you should find that all the information
should fit widthways on a portrait A4 piece of paper. You
might need to use a smaller font size. 10pt is a good
size.

Fonts

Here is a summary of the font
options available on this dialogue:

Select this option to display the current font being
used when generating general reports.

Select this option to display the current font being
used when generating away talk slips.

Select the first option if you want to
include the header on the generated report.

Select the second option if you want to
include the footer on the generated report.

Select the third option if you want to use
the chosen font for Normal Reports in the header and/or footer.

These options are disabled if you are
currently set to the Away Talk Slips font. The last
option will also be disabled if you opt to not include the header
and footer on the report.

This displays a sample of the font being used for the
selected report type.

Press this button to modify the settings for the
currently selected report type font. Once pressed, it invokes the
font selection dialogue. Click on the
link for more details.

If you do make changes to the fonts, you
must dismiss the dialogue by pressing the OK button. if you don't,
your changes will be lost. Once you press OK, any open reports get
redrawn using the new font settings.