This is one of three robust printing dialogues. The others are our Contacts Printing Dialogue and our Schedule Printing Dialogue. From this printing dialogue you can create and save any type of statistic report you wish. This include team and player reports. 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 View|Teams|Statistics. 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: Statistic record selection parameters on the left, and report layout parameters on the right.
Selection Parameters
The first section is the statistic record selection parameters in which you define all the parameters for which to select the statistic records to be reported. All of these parameters appear on the left hand side. You select to report on one league or all leagues, one conference, division or team and any data range.
Report Layout
The right hand side contains reporting formatting parameters. These will determine the layout of the report. There are two types of reports, offensive (Own Team) and defensive (Opponent). When you click back and forth between , you will see the list of fields in the Columns tab change. You can pick any of the statistics displayed.
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.
Include Jersey Number: Checking this box will add the Players Jersey Number along with the Players name.
Include Team Name: Checking this box will add the Team Short Name along with the Players name.
Portrait or Landscape: This prints on either 8.5x11 or 11x8.5 formats.
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.
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.
Select Field to Group the Report By: The software contains two grouping fields. The grouping fields will group Statistic records by the selected entries and create headings for them. These grouping fields are always the top one or two sort order columns. Note when certain fields are selected for grouping from the first grouping box, the second grouping boxes selections may be reduced.
Page Break when Group Changes: If you have selected a grouping, then this option will start each new group on a separate page.
Print Line Between Contacts: A line separator is printed between each contact record.
You may want to restrict what players or teams show up on the report. Under the Conditions tab you can enter any number of conditions you want. If you have entered statistics qualifying parameters through the Standings tab of the Leagues Screen, you will see a checkbox for ‘Show Qualified Players’. Checking this box will then only display players that have met the qualification standard. This option is grayed out and unavailable for team reports. The conditions grid can then be entered.
The sample to the left shows the conditions grid filled in with the following values: 1) Point per Game > 1 and 2) Games Played >= 20 and 3) Plus/Minus > 0. All conditions are joined with the ‘And’ function. Also, you can restrict the report through conditions on columns not displayed on the report. In this sample, no qualifying information was entered for this league, so the Qualifications Checkbox is not displayed.
The software has input for virtually any number of statistics. What some users have done is use statistics they do not track for conditional purposes. For example, if you were running a mixed league and wanted to report men and women separately, there is not way of selecting gender. However, by entering a 1 into a statistic not being used (such as face-offs won, or putouts) for women the very first time statistics are entered for each women, the condition of "Face-Offs Won > 0" selected all women. "Face-Offs Won = 0" obtained all Men. There are numerous other opportunities to use the conditions and statistical fields to achieve any condition you wish.
The other conditions that can be set (not available in the conditions grid) is a date range and Team(s). You can either report on all dates, or select a date range. First you will have to click the option button ‘Use Date Range Above’, then enter the From and To dates. You can also select to report on all teams, all teams in each conference, division or select a single team. If you select just a single team, then you can only run a player report.
Printing Reports
Once you have selected all statistics parameters and report formatting, you can show the statistic report on the screen in a grid or print the report on a paper report for printing. Clicking display will generate all statistics 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 statistic data into a comma delimited format. The CSV file can be read into Microsoft Excel or many other programs.
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.