Trouble Reports

1. Open the Edit, View, and Print Reports window by clicking the Reports button in the Navigator or Navbar.

2. Click the New Record button, type the name for the report, and select Trouble from the pull-down menu. Click OK.

If the report type already exists in the list, select it, then continue below.

3. Select a Page layout ñ either Portrait or Landscape (paper is printed on sideways).

4. Select a Font Size. Measurements are in standard points.

5. From the Report Items list, choose which fields to include in the report.

Phone # ñ the phone number of the payphone

Description ñ the description of the phone entered in the Phone window

User-Defined Category 1 ñ this information comes from the Phone window

Category 2 ñ this information comes from the Phone window

Category 3 ñ this information comes from the Phone window

Category 4 ñ this information comes from the Phone window

Alarms/Flags ñ this toggles whether or not to display the alarms and flags chosen in the Flags list in the right of the window

Date ñ this is the date that the flag was reported to Panorama

Amount in Box ñ the amount of money in the coin box as reported by the phone during the last communication with Panorama

No Communication ñ if the phone has not communicated with Panorama in the range of time specified for the report, this field will display the number of days since the last communication

No Coin ñ This field toggles whether or not to use the results of the Number of Days Back of No Coin field. If the box is checked, Panorama uses the Audit CDR records to determine whether or not a phone has collected any coins in the number of days back specified by the Number of Days Back No Coin field. Example: A report is run on 1/5/99, and the Number of Days Back No Coin field is set to 4; the report will produce a list of phones that do not have a value greater than zero in the Amount Collected field of the CDR record in all the days between and including 1/1/99 and 1/5/99. The generated report will display the phone and a 4 under the NO$ column. Also, if a phone has gone the Number of Days Back of No Coin, plus 15 days, the report will list the phone and a 99 under the NO$ column. This is an alert that the phone has gone an inordinate length of time without collecting coins.

Overdue ñ This field is based on the Options record settings (Reporting & Polling tab, General tab, Phone Reporting section), and will report a Y if a phone is overdue.

For the above listed fields, if the checkbox is clicked on, the check will toggle between on and off; but if the field name is clicked on, it will be selected and may be moved higher or lower in the hierarchy by clicking the up and down arrows.

6. If desired, select to have the information grouped by one of the four User Defined Categories with the Group report by field.

7. The following fields may be left blank or filled in:

Amt In Box ñ Specify how much money should be in the coin box (as reported by the phone during the last communication) to include the phone in the report. Enter an amount and select equal to, less than or equal to, or greater than or equal to. Example: ìAmt In Box: 5 >=î will yield a list of phones that have 5 dollars or more in the coin box.

Tot To Date ñ Specify how much money the phone should have made since the last power-up to include the phone in the report. Enter an amount and select equal to, less than or equal to, or greater than or equal to.

Amt Collected ñ Specify how much money the field technician should have collected in order to include the phone in the report. Enter an amount and select equal to, less than or equal to, or greater than or equal to.

Cash Box Vol ñ Specify the coin box percent full value needed in order to include the phone in the report. Enter an amount and select equal to, less than or equal to, or greater than or equal to.

8. Select the flags to list in the report. To find out what each flag means, move the mouse pointer over the flag without clicking it. A message will appear in the bottom of the window and directly under the mouse pointer to describe the flag. Click the All or None buttons to select or deselect all of the flags, respectively. If the Alarms/Flags Report Item of this report is checked, but none of the flags are checked, then any phone that has a flag will be included; conversely, if the Alarms/Flags Report Item of this report is checked, and only one of the flags is checked, then only the phones with that particular flag will be included in the report.

Note: If all of the fields are left blank, then all phones will be included. If one field is filled in, only the phones that are included in that criterion will be included. All fields in the Trouble report are ANDed, meaning each of the requirements that you set must be present in a phone in order for it to be included in a report. Example: If the Number of Days Back No Coin is set to 3, the Amount in Box is set to less than or equal to 5 dollars, and the DE flag is checked, then a phone would have to have not collected coins in 3 days, AND have $3 or less in the coin box, AND have reported a Defective Escrow relay flag to Panorama in order to be included in the report. All three requirements (or more, if you choose more) must be met, or the phone will not be included.

The layout meter displays how much of the page is occupied by information.

Customizing this report may require a few extra steps, depending on what is desired. Please see the topic Customizing the Call Accounting, Coin, and Trouble Reports.