Search results for query: *

Hello, I am using CR 2008 with an SQL DB. I am tying to create a report that shows where in our organization a case was resolved. -Tier 1 -Tier 2 -Outside Support (Dev, Engineering, etc) Some background information. A case will always be touched by a Tier1 as the initial contact. A case...

Hello, I am using Crystal 2008 with an SQL database. I have created a report from our CRM system that shows a listing of escalated "Cases". Case ID Name Description 12345 John Smith Test1 67890 Johnny Smyth Test2 What I am trying to do is be able...

We just upgraded to a new switch. (Avaya CS 1000) and Call Pilot 5. Desktop messaging has been activated however after I listen to the voicemail through Outlook, the Message Indicator light on the phone continues to blink and the CP MWI icon (on my PC taskbar)says that I still have a message...

Hello, I am using Crystal 10 and I am having a bit of a problem with a report. I will try to explain as best as possible. I am sorry for the length of this posting. The Main Report has a number of Cross Tabs in the header area and a section that shows me the following. Total number of cases...

Hi Everyone, I have a staff schedule presented to me in Excel. (I am using 2007) A 1,2 Merged (Person1) A 3,4 Merged (Person2) B1 - 9:00AM (Start of shift for person 1) B2 - 5:00PM (End of Shift for person 1) B3 - 10:00AM (Start of Shift for person 2) B4 - 6:00PM (End of Shift for person...

Hello, I am using CRX with SQL and I am trying to add a cross tab to my report with the following information. For tickets that are not equal to "Closed" 1-3 Days old 3-5 Days old 5-9 Days old > 9 Days old I found this posting by LBass a while back but the "aged0to30days" formulas do not work...

Hello, I am using CR X and I have 3 tables in my report. TableA is left joined to TableB by {CASE_ID} TableB is left joined to TableC by {SOLUTION_ID} (TableB and TableC are solution tables) Currently My data looks like this in my report. Case ID Status Customer Solution 123456...

CR 10 SQL Hello, I am pulling data from my CRM ticketing system to show me the following data: Case# Name Company Status Summary Solution 12345 Jsmith ACME Closed xxxxxx xxxxxx 54321 Rsmith IBM Closed xxxxx xxxxx The issue I am...

Hello, I am using Call Pilot Version 4.04 and this is the first time I have tried using the Password Check box. I added the password check Block and was able to record my prompt. When I dial the extenstion number that is tied to this application, I hear my recorded prompt but when I entered...

Hi There, I have read through quite a few posts on this however I seem to be missing something. I am using CRX with an SQL database in my main report and I am linking to a subreport which is actually an Access Database. The Main Report is grouped by: {person.name} and at each group level...

Hello, I did not find anything in the FAQ about this so here goes. I am using CR 10 with an SQL database and I have created a report that shows Support tickets, Agent name, Company Name, etc... The report looks like this: Ticket# Agent Name Company Name 12345 John...

Hi there, I am using CR10 with an SQL DB. I am currenly working on a report that will show me the number of support cases that were either opened or closed in a date range. This record selection works fine: {CASE.BUSINESS_UNIT}="SSPSG" and {CASE.ATTRIBUTE_ID}="PS_PSGPH" and...

Hello, I am using CR10 and I am trying to create a report that shows Case ID with the Solution of the case. {solution_table.CASE_ID} {solution_table.SOLUTION_DESC} (solution_table.ROW_LASTMANT_DTTM} The problem is that one case can have more than one Solution and I am getting multiple returns...

Hello, I am using CR-10 and am having trouble with the following: I am looking at a table that contains the history of a customer ticket. One ticket can go through several status changes and can be changed by several different Agents. Here is an example of 1 such ticket when I do an SQL query...

Hi There, I apologize for the length of this posting however I want to include as much detail as possible. I am using CR 10 and I am having trouble with a Subreport. My main report is very straight forward. It shows all the cases created within a particular date which is sorted by the...

I am not even sure if Crystal can do this but here goes. I am using CR X and I am pulling information out of PeopleSoft. I want to know when a ticket is Modified; the problem is that each time you choose the "Save" option during the creation of the case, the Database is updated here...

Hi There, Last week I migrated from MMail to CallPilot. I am using Symposium Express V 4.2 and have a number of seperate call treatments set up in this system. One of the call treatments allows you to leave a message which points to a voice mail box on call pilot. The problem is that if an...

Hello, My company is thinking of switching from Meridian Mail(13) to CallPilot v. 2.0 I am currenly using Symposium v. 4.2 for my voice mail boxes and call treatments. I would appreciate any feedback anyone has on such a move. Will I be losing any current functionality that I enjoy with...

Hello, I am using Symposium Express 4.2 Rev 7 and I am creating a custom performance report in Crystal. I want to add service level to my report and I am using the following formula. NumberVar TotalCallsday:=0; NumberVar CallsDelayedday:=0...

Hello, I am using CR 10 and I am trying to create a report with the following information: datatable.person_name datatable.date *If datatable.ticket_comp = Y then there is a completed ticket. I am trying to group data in the following way. Person 1 2005-10-10 75 (tickets) Person 2...