<DIV>I think you should take a look into the db_cra database. Specifically the table ContactCallDetail.</DIV> <DIV>If the data of your contact centers is stored in the same database, in the same table, there would be a security concern by giving one of your users access through ODBC, as he/she would be able to look at records of other contact centers.</DIV> <DIV> </DIV> <DIV>I have done custom reports using Crystal Reports (which rely on SQL Server stored procedures), never used ODBC to extract the data directly.<BR><BR><B><I>Ed Leatherman <ealeatherman@gmail.com></I></B> wrote:</DIV> <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">Curious how people handle reporting with IPCC Express.. we run a number of smaller call centers off of our IPCC Express system. Up till now we've just been generating reports using the historical reporting tool, but there are some units now that would like the reports to either
be in a different format or totally different reports altogether than what we can get from the canned tool. <BR><BR>Do most people use Crystal to accomplish this? Anyone provided an ODBC connection to more database savvy users? My database knowledge is pretty limited and I know zilch about crystal, trying to figure out the best way (security and performance wise) to handle it and still provide the info these folks are asking for. They already understand they will be doing anything special with reporting after-hours. <BR clear=all><BR>-- <BR>Ed Leatherman<BR>Senior Voice Engineer<BR>West Virginia University<BR>Telecommunications and Network Operations _______________________________________________<BR>cisco-voip mailing list<BR>cisco-voip@puck.nether.net<BR>https://puck.nether.net/mailman/listinfo/cisco-voip</BLOCKQUOTE><BR><p> 
<hr size=1>Luggage? GPS? Comic books? <br>
Check out fitting <a href="http://us.rd.yahoo.com/evt=48249/*http://search.yahoo.com/search?fr=oni_on_mail&p=graduation+gifts&cs=bz"> gifts for grads</a> at Yahoo! Search.