Search results for query: *

Running Crystal CR Developer Version 14.0.4.738 RTM Reporting against a Microsoft SQL database Have a report that was developed probably back in the Crystal version 6 days. Updated it to Crystal 7 and it ran fine for years. Recently I upgraded the report to Crystal CR Developer Version...

Hi All, We have an Definity S8500 CM 5.1 I'll trying to determine how our switch is programmed send calls to and backup our operator. I'm stuck at the point of this command "queue-to attd-group" When I right mouse click on the field for options, I'm given choices of "Attd-Group", "Attendant"...

Hi, We have an Avaya Definity S8500 Currently we use a vector to backup the operator when they are away from their desk. We are in the process of dropping the Call Center module and I'm assuming that we will loose vectoring when we drop the call center. If that is true, how can we backup the...

Using crystal version 14 with an MS SQL Table This formula is going in the suppressed details section and then I have a summary in the group footer I’m fairly certain I have done something like this before but today I just can’t get the syntax correct. Would appreciate your help. Wanting to...

Using an Avaya S8500 with Call Center enabled. Not sure of the version we are running but I believe it is version 5 (not sure how to check). I have an agent who has been receiving calls for a skill they are not assigned to. Checked all the things I know to check and everything seems OK to me...

We have an Avaya Definity S8500 Software version R015x.01.0.414.3. Does this build have a post call survey capability built in it? If yes, how does one go about setting it up. If it doesn’t, how would one go about adding post call surveys to the system, is there a 3rd party option? Thanks...

We have a Avaya Definity S8500 On our campus we have 2 buildings connected by fiber. The switch is in one building and it has 3 cabinets. In the other building we only have 2 cabinets. We are installing a tornado alarm and the way we are configuring it is we dial an extension and that kicks...

Hi All Working on a Definity S8500 and Call Center 5.0 Creating a new vector and next to one of my steps there is a # sign in an area where I'm not able to type. In the emulation view the line in the vector look like this 04#goto step 8 if digits = 2 a "good" line looks like this 05 goto...

Using Crystal Reports CD Developer version 14 Reporting on a DB2 table Have an existing report that pulls shipment records for the last 7 days using this formula {Mytable.Myfield} >= CurrentDate -7 Now they would like this report to pull the full month shipment records only if the current date...

Using Crystal version CR Developer version 14.0.4.738 RTM on a DB2 table I really like how Crystal allow you to Suppress a file but sometimes I have difficulty getting the syntax correct. This is one of those times. Have a report that prompts for ship to territories, it can also show all...

Using Crystal version CR Developer version 14.0.4.738 RTM on a DB2 table I’m converting a number field to text and prompting on the field. Sometime the converted number field results in a 0. If I prompt for 235 for example, it will return records with a 0 and 235. Why are the 0 records being...

Attempting to clean up a field that may contain a ; at the beginning of the field or the end of a field. Thought I could use the replace function with a right function but does not seems to be working. How would I go about removing a character if it is only found at the beginning or ending of a...

Using CR Developer version 14.0.4.738 RTM Reporting from a MS SQL Database Have a report that is grouping by the customer number so by default it is sorting by customer number. I have been asked if it would be possible to sort by the total sales dollars. The total sales dollars is a Running...

We are implementing Salesforce and we are moving our Crystal reports to the SF reporting tool. The implementation partner is requesting that we document the existing report by giving them the column header name and the database field name. Something like: Column Header Name / Database Field...

Using a MS SQL database and Crystal version 14.0.4.738 RTM We have a standard report on calls received. The report users like to receive the report for calls received that day, for the prior week and for the prior month. Currently to accommodate their wishes, I have 3 versions of the report...

Designing a report that has several different date fields, for example Manufacturing Date, Ship Date, and Install Date. The user wants to be able to provide a date range and they also want to be able to be prompted for all 3 date fields. Depending on which date field they select, one date range...

Using Crystal CR Developer version 14.0.4.738 and a MS SQL database Was using this formula in Crystal version 7.0 without any issues but in version 14 it throws the error "Month number must be between 1 and 12". The formula is: {@DateClosed} in Date (Year (CurrentDate),Month (CurrentDate)-1 ...

Have a 10 position text field that stores our serial numbers. The first 3 positions of the serial number can contain all digits, all alpha or mixed alpha and digits. Need a query that will only select the records if the leading 3 characters are each alpha. Tried several different things but...

Looking for a program that can search thru RPT files for a string of characters. For example lets say I'm looking for all the reports that have a formula that contains the string "if area =" The tool will read thru all the reports that are in a directory and produce a list of reports that...

I have an If Then Else statement that is for a date field. For the else part of the formula I would like to put in a blank something like ToText(“”) but Crystal throws the error “A date-time is required here. Ultimately this is being exported to Excel, when it is opened in Excel I would like to...