Custom report

Introduction

This is the most flexible (and often daunting) report. For those who feel they want more information than is provided in the in-built reports, you can specify exactly what search terms you want to look for, including new additions such as CLI (Calling Line Identification) and LCR (Least Cost Routed) calls.

Running the report

On the Reports screen, either double-click on the Custom report in the reports list or highlight the Custom report and press Run now as shown below.

The following report selection criteria window appears:

Select a report period

You need to select a time period for which you want the report to produce information for. You can select a pre-set period from the drop-down list as shown below:

The default is set to Last Month (the period from the first day to the last day of the previous calendar month, and NOT the last 30 days).

To select a period of your own, choose Custom Period from the list, then enter your start and end dates and times in the boxes provided:

Choose a site to report on

If your system is set-up to administer multiple sites, you have the option of selecting a particular site here. Select the blank line (or leave the box empty) to report on all of your sites.

Select a type of call(optional)

You can report on certain types of calls. You can do this by selecting them from the drop-down list, which is provided:

If this is left blank all types of calls will be reported on.

Specify an extension range

You can report on more than one extension number. In the fields provided you need to enter the 'from number' and then the 'to number'. If you would like to report on an individual extension in the 'from number' enter the extension number and then enter the same extension number in the 'to number' field.

Choose an extension group (optional)

This is an optional feature, you can specify an extension group which is provided from the drop down list or simply leave it blank and it will do all the extension groups that have been set-up on TIM:

Specify a trunk range (optional)

You can report on more than one trunk number. In the fields provided you need to enter the 'from number' and then the 'to number'. If you would like to report on an individual trunk in the 'from number' enter the trunk number and then enter the same trunk number in the 'to number' field.

Choose a specific trunk group (optional)

You have the option of selecting a trunk group to run the report for. You can do this by selecting the trunk group out of the drop-down list, which is supplied:

Specify a partial dialled number (optional)

You can search on partial or specific numbers. If you wanted to find out all pagers, personal and mobile numbers that are being called you could enter 07 in the field provided and when the report has been processed you will get all the pagers, personal and mobile numbers:

Specify a named destination

You can search on partial or specific named location. If you wanted to find out all calls to London, you could enter London in the field provided and when the report has been processed you will get all the calls to London regardless of the dialled number:

Specify a call duration range (optional)

You can report on calls between a certain call duration. In the fields supplied, enter the from duration in hours, minutes and seconds (hh:mm:ss) and the to duration in the same format:

Specify a response time range (optional)

You can report on how quickly your incoming calls are answered by specifying the exact response time range here. In the boxes supplied, enter the from time in seconds and the to time in seconds:

Specify a call cost range (optional)

You can report on calls above and under a certain cost. In the fields supplied you need to enter the from cost and to cost:

Specify a partial Caller ID (optional)

You can find out who is calling you organisation, you can do this by inputting the calling number e.g. 02079207095 and it will show you how many times they have called your organisation (this all depends on your telephone system outputting the information). If you just wanted to see how many calls you are receiving from Bristol then, all you need to put in is the dial code, which would be 0117:

Specify an account code

You can report against a single account code or a range of account codes by typing them in the box below. If entering more than one account code, comma separate as follows 1147, 1153, 1178 etc.

Select a field to order the results by

This gives you the option to order the result by any field on the report. You can do this by choosing a selection from the drop-down list. If no sort field is selected, the results will be ordered by the date and time calls were introduced to the call database, which is not necessarily the same as selecting DateTime from the field list. Therefore, if you want the results in order of date and time, you are advised to explicitly select DateTime from the list.

Sort Order

The default order in which the results are sorted is ascending - from smallest value to highest value. You can select to view the results in descending order by selecting option here.

Creating the Report

When you have chosen a reporting period, and are happy with your selections, click on the Run Now button.

The results

Because of the number of selection parameters available on custom reports, the results can vary. The example below show outgoing calls to mobile during a specific time period. Because outgoing calls only was selected, there are no CLI's showing.

The header contains the date and time the report was generated, the period the report covers, and an indicator for each of the report's criteria that you selected, if any.

The report consists of a single table housing all of the calls that matched your selection criteria. Each column of the table is described here: