Contents
Index

Area Code/Exchange Summary Report Help

Report View Toolbar

When viewing a Crystal Report in the Workspace, several options are available from the Report View Toolbar. To learn more about these options, on the graphic below pause the mouse pointer over a button to display its function, and click to display more information.

Exporting a Crystal Report

You can Export a report to a Formatted or Unformatted file type. To export a report, on the main toolbar, click the Export button . On the drop-down menu, point to Formatted or Unformatted. Available Formatted file types are: Excel, HTML, PDF, Text, or Crystal RPT. The available Unformatted file type is CSV.

This report lists all outbound calls by area code, and includes total duration of calls, total calls to that area code, and average duration of calls to that area code. The international version of this report is the International Remote number Logical Component 2 Summary. The Area Code Summary report provides managers with regional calling patterns. By using this report, management can determine the distribution of calls to various regions of the country.

Parameters

You specify the range of country codes, area codes (enter a "-" (dash) for a null value), site IDs, and date times as parameters. You can specify all or part of a day in the time range.

Report Log Tables	Interaction Administrator Unique Report Identifier
CallDetail	AREACODE_SUMMARY_NAME

Sample report

Click on the image below to view a sample of this report.

Report Elements	Report Field or Value	Field or Value Description
Country Code	RemoteNumberCountry	The country code called from this site.
Exchange	RemoteNumberLoComp2	The exchange called from this site.
Area Code	RemoteNumberLoComp1	The area code numbers called from this site.
Total Duration	Sum(CallDurationSeconds)	The sum of CallDurationMinutes of outbound calls placed within the specified region or area code.
Total Calls	Count of RemoteNumber	A count of the number of calls made to this area code.
Average Duration	Sum(CallDurationSeconds) / Count(ConnectedDate)	The average amount of time of outbound calls placed within the specified region or area code.

Record Selection Criteria:

{CallDetail.CallDirection} = "Outbound" and

{CallDetail.ConnectedDate} in {?StartDateTime} to {?EndDateTime}and

{CallDetail.RemoteNumberCountry} in {?StartRemoteNumberCountryCode} to{?EndRemoteNumberCountryCode}and {CallDetail.RemoteNumberLoComp1} in {?StartCode} to {?EndCode}and

{CallDetail.SiteId} in {?StartSiteId} to {?EndSiteId}