This is one of three robust printing dialogues. The others are our Contacts Printing Dialogue and our Statistics Printing Dialogue. From this printing dialogue you can create and save any type of schedule report you wish. This include team reports, officials schedules and fieldlocation schedules. If you have used our statistics screen before, you are away that you can create and save different statistics reports and this is similar. In order to access this print function, use the menu bar and select Reports|Schedule Printing. The following screen will appear.
This dialogue has a number of very unique features that you should read through prior to creating reports. There are two main sections of this dialogue: Schedule record selection parameters on the left, and report layout parameters on the right.
Selection Parameters
The first section is the schedule record selection parameters in which you define all the parameters for which to select the schedule records to be reported. All of these parameters appear on the left hand side. Games status can be selected and schedule formats. Note: if you select a particular schedule, the schedule format select is not available.
When selecting many of the elements like Officials Name, Schedule Type, etc, you will notice a Special Pulldown Type which you should read about briefly before using them.
FieldLocation Availability can also be printed. Since no games are yet scheduled on these available time slots, no game details will be printed. They can be printed with other schedule records containing games. If this checkbox is selected, the Game Duration field is made available. Since available slots do not necessarily indicate single games, if a duration is entered, available slots will be divided into slots matching the game duration. If you wish the entire slot to show undivided, then leave the Game Duration box empty or zero.
Report Layout
The right hand side contains reporting formatting parameters. These will determine the layout of the report.
The top section are the columns which will appear on the report. The following described each option from this selection grid.
Select: In order to place a column on the report, it must be selected by placing a checkbox in this column.
Column: This is the system name for the column. It is for reference and cannot be changed.
Display Label: This is the heading you wish to used for the selected column.
Display Order: This is the order the columns will appear across the top of the report. If two columns have the same number, they will be stacked one on top of the other (see stacking below).
Sort Order: This determines the order that the contacts will be sorted on the report.
Width: Width of the column (in twips)
Justify: Data and headings for a column can be left, center or right justified.
The following is a description of the fields appearing below the columns grid.
Date Format: Fields that are displayed as dates will use this format.
Font: This is the base font, color and size for the main records of the report. Column headings and titles will use the same font and color, but increase the size proportionally.
Use Teams Short Names: This will use the teams short name for all team names or combination of names in the report
Print in Calendar Format: This prints your report in a monthly calendar format.
Portrait or Landscape: This prints on either 8.5x11 or 11x8.5 formats.
Week No. Start Date: Several users have asked to print a week number on the report corresponding to the start week of the league. Since you may be printing records that are not at the start of the season, this field will determine the first day of the league from which week numbers will start. All games during the first week are week 1 and so on.
Select Field to Group the Report By: The software contains two grouping fields. The grouping fields will group schedule records by the selected entries and create headings for them. These grouping fields are always the top one or two sort order columns. Note that if you group by Official, the software will create individual schedules for each official which could be time consuming.
Page Break when Group Changes: If you have selected a grouping, then this option will start each new group on a separate page.
Print Sub Totals if Displaying Fees: This report allows you to print the fees associated with officials, fieldslocations, and teams. Checking this option generates a summary line with the grouping field changes. This is only available if a fees field is selected.
Print Report Totals if Displaying Fees: Check this option to display a Report total of all fees displayed at the end of the report. This is only available if a fees field is selected.
Print Sub Totals Only: This option will print only the sub total or report total line and no scheduling details. This is only available if a fees field is selected.
Compare Fees: If you are sub totalling team fees fields and then you can compare those fees against the fees entered on the teams screen.
Print Line Between Schedule Records: A line separator is printed between each contact record.
Web Publishing
Not all web publishing of your data has to occur on the Web Publishing screens. On the screens where Web Publishing Supports the publishing of data, there will be additional fields to support and customize the publishing of data. On the Schedule Printing Screen, there are three fields:
Short Name: This is used with Web Publishing when display a specific report on a web page. You refer to this report on your web site with this name. The name has restrictions on the use of special characters. Ideally it should be a single word with no spaces.
Template Name: You can add a number of different templates through the Web Publishing Look and Feel screens. For each report you wish to publish you can select to use the default or customized template.
Publish Button: This button may be active or inactive. If the button is active then you simply click the button to publish the report. If the button is inactive you must sign into web publishing from the login screen. In order to login, you must first sign up for the web publishing service through www.analyzersoftware.com.
Printing Reports
Once you have selected all scheduling parameters and report formatting, you can show the schedule on the screen in a grid or print the report on a paper report for printing. Clicking display will generate all schedule records into a grid for display. The Print button will generate a report which will also be shown on the computer, but can then be printed to any format. Displaying the report in the grid will not perform all the grouping and stacking that a printed report will. Once the grid is displayed, click the "Hide Grid" link to show printing parameters once again.
Exporting Information
Click the Export button will prompt for a CSV filename for the software to store the schedule data into a comma delimited format. The CSV file can be read into Microsoft Excel or many other programs.
Stacking Columns
You have the ability to stack columns on the report (you should be thinking...that's cool). There are many different fields to print and spreading them all across one line of a report can be limiting. Therefore, you can stack fields on top of one another.
In order for stacking to occur, the fields to be stacked must have the same number in the display order columns. The sort order column will determine the order of the stacking.
A quick issue you have probably already thought about is the display label or column headings...how is that handled? Well, we thought of that as well. The display label has some flexible functionality. In the screen shot above, the teams are going to be stacked with the fields appearing on top of each other. In order to stack, the display order must be the same (in this case 4 & 5). Therefore, Visting and Home teams will be stacked along with their scores. The stacking order is based on the sort order column. With stacking columns you have one column heading and this is taken from the display label of the first column in the stack. However, if you where stacking another type of field like phone numbers, the heading might be phone numbers, but how could you tell which number was which (cell, home, work, fax, etc.). Well the display label can also help out. Any time you have a display label with a pipe ("|") in it (stacking or no stacking), everything to the left of the pipe is a column heading, everything to the right is an inline report heading placed immediately to the left of the field. In the example above, the word "at" is piped to show next to the home team and would be printed as follows:
Notice that the teams are left justified with the heading. The inline report label appear to there left, so you will need to ensure that your column to the left is wide enough to accommodate the label and its own data.
When you do save a report, all parameters and formatting information on the screen is saved with the exception of the data. When the report is saved and run at a later time, it will pick up new data in the system.
You have several options around saving reports. When you click the ‘Save’ button, the report displayed is replaced by all data entered, even if the report name changed. You can also select an existing report, make modifications to the report format and click the ‘Save New’ button and the existing report is not modified, but a new report is saved. This allows you to start with a general report as a template and make modifications saving with the Save New button to create a new report.
That is it for this function. If you have any feedback on any of these features, we would sure enjoy hearing from you.
The printing of tournament/play-off data is unique in several ways. Since the software allows the user to set up tournaments ahead of time, prior to knowing teams, the printing of those games is a special case. What many users are looking for is the ability to schedule play-off games and have them appear on each teams or divisions schedule. This is exactly what are software allows. If the tournament is set up properly (see Tournament Management for information on how to correctly set up this scenario) all play-off games will appear once if sorted by date, appear once for each team selected on the Schedule Details tab, or appear once for each division that has a team selected on the Schedule Details tab.
This type of printing only works if no specific schedule is selected. For non-playoff tournament schedules, games are typically printed on their own and not with regular season games.