Toshiba Phone System

I need help with a formula in Crystal Reports Version 9!?

Okay, so I'm a "technology dude" at this company. We run a gourmet train up and down the valley. In order to ride the train, people need to call into the reservations department. Recently, we switched our phone system to Avaya IP Office, and now my managers want reports from CCC Reporting listing all of the lost calls in a day. I purchased Crystal Reports V.9 to create custom reports for their needs, but I've run into a problem... I cannot successfully find/create a function or equation to display all the callers who had called the reservations department and abandoned the call after 30 seconds had passed. Also, I cannot get the report to just show "lost" calls. So, before I bang my head against the keyboard due to exhaustion from this crazy task, here is what I need: 1) A formula showing the exact time a caller waited before hanging up. 2) A formula that only lists "Lost Calls" on the report, rather than all of them. Please can anybody help?!

Public Comments

1. You don't need a formula, you need a database select statement. Does the database you're running against even contain the data you want? If so, where are the fields and what are the values in them? Answer those questions, and you'll be able to create the "select" in Crystal to pull just the records you want.