Reports

Custom Report Setup

Custom Reports Setup Dialogue All Entries End Date Start Date Variables Custom Report Scripts

The Custom Reports Setup page allows you to select a custom report and setup a variety of options to determine how the reports get generated. To be able to access this setup page, you must select Custom Reports from the list of report types on the Report Type tab.

All the settings are saved when you dismiss the dialogue by pressing the OK button.

To learn more about the features of this property page, glance down the table below or highlight the control you are interested in by clicking on the screenshot above. Please also remember that context help is available to you by either pressing F1 when the control has focus, or by using the question mark icon at the top right corner of the dialogue.

This property page is one part of the Choose Report Type Dialogue. Please click on the link to get an overview of the entire dialogue.

This list box displays all the custom report scripts that you have available on your computer.  This list of scripts is maintained by using the custom reports maintenance page.

The start date is used in conjunction with the end date.  This limits how much database information is available for use in the generated report.

For example, if you are looking at a home talks schedule, or a watchtower and readers schedule, you are likely only interested with all the database information within a certain date range.

Use these options to set the date range.  Note, though, that the date range ONLY applies to Home Talks, Away Talks, Public Talk Titles and Congregations tables - it has no effect on any other table, even ones you may have added. It will be ignored for any other table.

These options will be disabled if the All Entries option is on.  See below for details.

The date range gets stored between instances of using the program.

The All Entries setting will override any start/end date range currently specified.  It ensures that all database information will be available inside the generated report.

The setting gets stored between instances of using the program.

This button will get enabled or disabled as you select a custom report from the list.  If it gets enabled, then you MUST click on this button to display the variables dialogue:

This dialogue displays all the prompts that are in the script file.  These prompts were set using the REQUIRES script command.  For each prompt, you must specify a text value.

If you used the AwaySpeaker variable it will present a list of your away speakers to choose from.  If you used the Congregation variable it will present a list of your congregations to choose from. This is for use with LOOP and IF criteria. Look at the script editor help topic for full details.  For any other variable you must simply go ahead and type in the variable text.  Then hit OK.

By doing this, when you generate the report, these values will get used in the report.  This makes the custom reports feature very powerful.

Custom Report documents are different in the way they are displayed.  As you will see when you use them, they show as "pages".  At the bottom of the document is this page toolbar that allows you to move through the pages or jump to a page.