<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:st1 =
"urn:schemas-microsoft-com:office:smarttags"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3132" name=GENERATOR><!--[if !mso]>
<STYLE>v\:* {
BEHAVIOR: url(#default#VML)
}
o\:* {
BEHAVIOR: url(#default#VML)
}
w\:* {
BEHAVIOR: url(#default#VML)
}
.shape {
BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceType"></o:SmartTagType><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceName"></o:SmartTagType><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"></o:SmartTagType><!--[if !mso]>
<STYLE>st1\:* {
BEHAVIOR: url(#default#ieooui)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Tahoma;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: blue; TEXT-DECORATION: underline
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: "Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
SPAN.EmailStyle20 {
COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal-reply
}
DIV.Section1 {
page: Section1
}
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=EN-US vLink=blue link=blue>
<DIV dir=ltr align=left><SPAN
style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: medium; COLOR: black; FONT-STYLE: normal; BACKGROUND-COLOR: white"><SPAN
class=134373313-11072007><FONT face=Arial color=#0000ff size=2><FONT
color=#000000>I'm trying to run some reports for HR on a secretary and her
calls. All I want to get is a listing of all the calls the received
and made during a time period. Doing a CDR search gives me tons of
info, but I can't figure out the layout of the .TXT file. It's
actually been easier to just do a CDR export and pull it into Excel, sort
the data and grab just the records I
need. </FONT></FONT></SPAN></SPAN></DIV>
<DIV dir=ltr align=left><SPAN
style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: medium; COLOR: black; FONT-STYLE: normal; BACKGROUND-COLOR: white"><SPAN
class=134373313-11072007></SPAN></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN
style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: medium; COLOR: black; FONT-STYLE: normal; BACKGROUND-COLOR: white"><SPAN
class=134373313-11072007><FONT face=Arial size=2>The problem </FONT><FONT
face=Arial size=2>is the DateTime fields. Anyone have a formula to change
this to a date HR can read? I assume it's something like the number of
seconds since Call Manager was born, but any help is
appreciated.</FONT></SPAN></SPAN></DIV>
<DIV><SPAN
style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: medium; COLOR: black; FONT-STYLE: normal; BACKGROUND-COLOR: white"><SPAN
class=134373313-11072007><FONT face=Arial
size=2></FONT></SPAN></SPAN> </DIV>
<DIV><SPAN
style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: medium; COLOR: black; FONT-STYLE: normal; BACKGROUND-COLOR: white"><SPAN
class=134373313-11072007><FONT face=Arial size=2>I know there has been
discussions on here before about Call Manager's reporting, but I wanted to say
it again, it's really overly complicated. Has anyone done anything using
Crystal Reports against the CDR database? I wonder if that would be
easier?</FONT></SPAN></SPAN></DIV>
<DIV><SPAN
style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: medium; COLOR: black; FONT-STYLE: normal; BACKGROUND-COLOR: white"><SPAN
class=134373313-11072007><FONT face=Arial
size=2></FONT></SPAN></SPAN> </DIV>
<DIV><SPAN
style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: medium; COLOR: black; FONT-STYLE: normal; BACKGROUND-COLOR: white"><SPAN
class=134373313-11072007><FONT face=Arial size=2>Thanks in
advance....</FONT></SPAN></SPAN></DIV>
<DIV><SPAN
style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: medium; COLOR: black; FONT-STYLE: normal; BACKGROUND-COLOR: white"><SPAN
class=134373313-11072007><FONT face=Arial
size=2></FONT></SPAN></SPAN> </DIV>
<DIV><SPAN
style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: medium; COLOR: black; FONT-STYLE: normal; BACKGROUND-COLOR: white"><SPAN
class=134373313-11072007>
<DIV align=left><FONT face=Arial size=2>Geoff Rhodes</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Director, Information
Technology</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Robinson, Bradshaw & Hinson,
P.A.</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>704 / 377-8188</FONT></DIV>
<DIV align=left><FONT face=Arial size=2><A
href="mailto:grhodes@rbh.com">grhodes@rbh.com</A></FONT></DIV>
<DIV align=left><FONT face=Arial size=2></FONT> </DIV></SPAN></DIV>
<DIV dir=ltr
align=left><BR></DIV></SPAN><!-- END-ANTISPAM-VOTING-LINKS --></BODY></HTML>