Maintain Databases

Custom Reports

Custom Reports Maintenance Page All Entries End Date Start Date Scale View Delete Copy Modify New

The Custom Reports property page allows you to maintain a selection of custom report scripts.  Custom report script files are required to be able to produce your own custom reports. You can add, delete, modify and copy the scripts as required.

It is important to understand the concept of what a custom report script file is.  Clicking on the relevant links below will take you to all the information you need in order to use script files.  Of course, it is recommended that you view the supplied sample scripts also.  Using the sample scripts and reading all the help documentation concerning custom reports, you should be able to generate your own scripts with relevant ease.

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 Maintenance Dialogue. Please click on the link to get an overview of the entire dialogue.

Custom Reports maintenance page

Pressing the New button allows you to create a new script file.  To begin with, it brings up an edit box for you to specify the name for the script.  You will not be allowed to duplicate an existing script in the list.

If the new script name is valid, it then brings up the script editor.  Using the editor you can create the new script.  Click on the link for more detailed information.

Modify

Pressing the Modify button allows you to alter an existing script file.  You can alternatively double click the script name in the list box to modify it.

It then brings up the script editor.  Using the editor you can alter the script.  Click on the link for more detailed information.

Copy

Pressing the Copy button in similar to pressing the New button.  The only difference is that it copies the contents of the currently selected script  into the new script by default.

Otherwise, it behaves exactly as for pressing the New button.

Rename Pressing the Rename button allows you to change the name of the custom report script. You can also use CTRL + R.
Delete Pressing the Delete button (or the Delete key) allows you to delete the selected script file from your list of scripts.  You are asked for confirmation before the script is deleted.  Once deleted, it cannot be retrieved.
Scale View

The setting of the Scale View option determines how the script editor intially behaves.  The setting can also be changed from inside the script editor.

If the setting is on, then the view of the page in the editor is scaled to fit the width of the page, the height takes on the same scale and thus may be shorter than the window.  In other words, the editor's view shows the whole page at once.

If it is off, then the editor will show the view at 1:1.  It will be necessary for you to scroll left and right in order to view the whole width of the page.

The setting gets stored between instances of using the program.

Start Date

End Date

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

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.  You can override the date range limit inside the script itself.

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.

All Entries

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

The setting gets stored between instances of using the program.