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

Click on the function button, on the top right-hand side of the main application window to access the Reports screen.

From this screen, either double-click on the Custom Report in the reports list or highlight the Custom Report and press the button, 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.

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).

Or enter your own custom period

If you want to specify a period not shown in the list, just enter your start and end dates and times manually into the boxes provided.

Choose a site

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

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 Number from - to. If you would like to report on an individual extension in the Number from enter the extension number and then enter the same extension number in the to field.

Choose an extension group

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

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

Choose a trunk group

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

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 (hh:mm:ss)

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

Specify a response time range (hh:mm:ss)

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 response- to in hours, minutes and seconds (hh:mm:ss).

Select a call cost range

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

Specify a partial Caller ID

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 drop-down 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 this 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: