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.
 
Report Type Dialogue Select Font Sample Apply to header/footer Include Footer Include Header Away Talk Slips Normal Reports Report Type

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 (click on link to see setup help topic)

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.

Away Talks (click on link to see setup help topic)

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.

Congregations List (click on link to see setup help topic)

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.

Click on the link for more information about this.

Home Talks (click on link to see setup help topic)

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.

Hospitality List (click on link to see setup help topic)

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.

Talks Annual Review (click on link to see help topic)

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 the S-99 form 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 report is not intended to replace the form S-99.

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

  • A word processor, (for example, Microsoft Word OpenOffice Writer) to open, edit and save the HTML document
  • A spreadsheet program (for example, Microsoft Excel, OpenOffice Calc) to open, edit and save the DIF document.
Talks By Category (click on link to see setup help topic)

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.

Talks List (click on link to see setup help topic)

The Talks List report produces a list of all the public talks. Options specify exactly how much information is included on the report and how the talks are sorted.

The following information is generated for each public talk:

  • Talk number
  • Theme of talk
  • Talk category (optional)
  • Date the talk was last heard at your Kingdom Hall (optional)
  • How many times the talk has been heard at your Kingdom Hall (optional)

This report has been designed to assist you in deciding what public talks you would like heard next at your Kingdom Hall.

Talks Summary (click on link to see setup help topic)

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.