[cisco-voip] IPCC Express Reporting access

[Cucumber Green]

I think you should take a look into the db_cra database. Specifically the table ContactCallDetail.
  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.
   
  I have done custom reports using Crystal Reports (which rely on SQL Server stored procedures), never used ODBC to extract the data directly.

Ed Leatherman <ealeatherman at gmail.com> wrote:
  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. 

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. 

-- 
Ed Leatherman
Senior Voice Engineer
West Virginia University
Telecommunications and Network Operations _______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

       
---------------------------------
Luggage? GPS? Comic books? 
Check out fitting  gifts for grads at Yahoo! Search.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20071004/a5f8e620/attachment.html