Hansen Call Management

v2603

Site: Main

Call Detail With Grade

Select Field

Select field from dropdown

Select Criteria

Report Rules

SortNum	OrderBySortNum	RowType	FieldTypeCommon	FieldName	FieldDesc	SQLText

Enter in top count:

OrderBySortNum	OrderBySortNum2	Select Field	SortNum

IIf(IsNumeric([Account]),Cdbl([Account]),0)	Case When IsNumeric([Account]) = 1 Then Cast([Account] as Float) Else 0 End	Account Number	Account
[Costed Call Records].[Area Code]		Area Code	AreaCode
[Call Type]		Call Type	TypeOfCalls
City		City	City
Country		Country	Country
Date		Date	Date
IIf(IsNumeric([Departments.Department]),Cdbl([Departments.Department]),0)	Case When IsNumeric(Departments.Department) = 1 Then Cast(Departments.Department as Float) Else 0 End	Department Number	Dept
[Adjusted Duration]		Duration (in seconds)
[Costed Call Records].[Exchange]		Exchange
[CRGrade]		Grade	CRGrade
Line		Line	Line
[Net Cost]		Net Cost
[Net Cost] + [Surcharge]		Net Cost + Surcharge
Formatted_Phone_Number		Phone Number	PhoneNumber
IIf(IsNumeric([Pin Number]),CLng([Pin Number]),0)	Case When IsNumeric([Pin Number]) = 1 Then Cast([Pin Number] as Float) Else 0 End	PIN Number	PinNumber
SiteNum		Site ID	Site
State		State/Prov	State
Station		Station	Station
[Costed Call Records].[Suffix]		Suffix
Time		Time	Date
Trunk		Trunk	Trunk

N N