Search results for query: *

I have a client with 2 long back to back desks. Each side has 5 phones and the reps get confused when the phones ring as to whos phone is actually ringing. They are in the area but not at their desks a good amount of the time, so it would be great if I could put distinctive rings on 10-14...

I have a small client with only 4 analog pots lines. They would like to have the 2 sales people able to use mobile twinning. Is there a work around to allow mobile twinning with analog lines or do you have to have a T1 to make mobile twinning work? It would be a new IP office install. Thanks

Quick details about what I am trying to do and what my table looks like. Guts of the table is 3 colums Company name | Deal name | Deal manager Goal is an excel export that looks like Company name | Deal manager 1 | #of deals with company | Deal Manager 2 | # of deals with company So that...

I have a paramater field that i use to select records for just 1 "user name" As of now I have to manualy update this field anytime the "user name" table is changed. Is there a way to have a parameter field auto populate from a field in the DB or a formula field? Im running crystal 8.5 now but...

I am trying to set up a parameter field so the user can select what field to sort on. I have used text and numbers in the same formula before but this time the data fields are a combo of date(##/##/##) Currency($#######.##) Percentage(##.##%) and text All the sorts work in this formula...

I have a few parameter fields in my report that have an "All" option. I would like to have my selection criteria based off of the field but it should not filter anything if "All" is selected but I am having trouble getting the results i want. Here is what i have parameter...

I am looking for a way to have users select report info based off of a drill down. I was thinking of using parameter fields but could not figure out how to do it. Ex. User is prompted to Select the type of report you want to run Division Department Section The next menu will only offer the...

I am trying to set up a parameter field so the user can select how they would like a report sorted. The issue is the fields they want to choose from are Account name (text) Estimated close date (date) %chance to close (numeric) estimated value (numeric) total fees (numeric) The...

I am trying to print out letters from a report that need to be mailed. I need to print out a varying number of letters depending on how many contacts are listed per account. The letters are grouped by account# with every contact for that account listed on the second page. In the exmple below...

I have a text data field that I need to reformat. I need to take a 6 char text field and insert an "-" between the 5th and 6 char. ex becomes 123456 12345-6 222230 22223-0 I was just looking for the easiest way to accomplish this...

I am trying to so a selection function that will show me any records where one field in paticular is in all caps. I tried to use the selection criteria trim({NAME.CADD1}) = Ucase(trim({NAME.CADD1})) But the = seems to show just where the letters are equal regardles of the case. Could...

I am trying to format a field to ALWAYS be 9 chars wide. The formula below works except when the field is blank. If the field is blank it skips the field without adding the spaces. Any help would be greatly apperciated. If ((length(trim({NAME.CCOUNTRY})) < 5) or...

I need to create a flat text file ,1 record per line no breaks or delimiters, that is 380 chars wide. Some fields are static others need to be drug in from the DB. I have two questions. 1. How do I tell crystal that I dont care about the page size because the output is going to a file(or at...

Where can Download ODBC drivers for SQLBase? Im trying to configure Crystal Reports to work with an app of ours that uses SQLBase as its underlying DB. When I went to setup the ODBC bridge I saw that I dont even have the choice of SQLBase as one of my drivers. Thanks

What is the syntax for ordering results by multiple fields. For example i want to order by tblCourses.CourseName then by tblSessions.date TIA for the help, WH

I have a linked table with a date field that is in the format YYYYDDMM eg 20012902 I need to use this number to run a report that shows everything 60 days old or greater. I can not get access to see this number as a date. I have been able to split the date into 3 seperate fields while...

Hopefully I am just missing something here.... I have a form with multiple choice questions that I use radio buttons for and two free form answers that I use text boxes for. The multiple choice questions work fine but I cant seem to get the info from the text box to take. Im using the same...

Hopefully this isnt to bad.... I have a web that links into a SQL DB. It is used to update records. As of now when you input info and hit enter on the form it updates the DB with an insert query. In order to limit the number of errors they would like to send the info to a validation page that...

I have a SQL datasource set up that I use to feed our divisions training intranet site. My EmployeeInfo table contains the fields employee# and password. On the site there is a form that is used to check what classes you have taken. I would like to use the input from the form to run the query...

I trying to set up a web site using ASP to run queries from a linked SQL datasource. I can get all of them to run right but I would like to have one query run only if the user# matches the password. I have a user# and password field in one of the tables but I can not figure out the syntax to...