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...

Not the answer I wanted to hear but glad to get it now vs after i spent any more time on it. Thanks for the quick response and happy coding.

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...

In my report I have a parameter field that picks the status of an account. The default values are All Closed Closed - Decline Closed - Lost Closed - Won Open In my selection formula i used the code ( if {?Status} = "All Closed" Then {OPPORTUNITY.STATUS} in ["Closed...

Thanks for the reply..was just testing the same thing when i got the mail. Thanks again.

I used this to solve a similar problem if {?Degree} = "All" Then {Deg.DegName} in ["Deg1", "Deg2", "Deg5"] else {?Degree} = {Deg.DegName}

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...

Thanks again for the help guys. I should have been able to get that one on my own, must have been having a bad day. Thanks

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 think i got it. I was able to get it to sort in the correct order by converting tostring and forcing spaces into the begining of the string. ex If {?SortOrder} = "Fee Amount" Then totext({OPPORTUNITY_PRODUCT.FEE_AMOUNT},"##########") my numbers now sort in the...

Ive tried to use the formatting commands but they seem to be more for changing the way the results are displayed...commas, #of digits, decimal point etc.. My problem is that if i try to sort the numbers 1,5,10 I get 1 10 5 because it is putting them in alphabetic order not number. If im...

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 understand now. I was going about it the entire wrong way and looking at the report itself and not at the data. Dont know what I was thinking. I remade the queries to reflect the changes that you said back in the first response and it works fine. Thanks for putting up with my...

Im sorry for being so unclear, let me try to lay it out a little better. The report is an access report. It is setup to be grouped by account number. I have the letter in the <account# header> section I have a page break at the end of that section then the <detil> section contains the...

My table structure is (in breif) Accounts Account# open_date Account_admin Contacts Account# first_name last_name They are linked by account# with a one to many(one account many contacts) The problem I am having is there are approx 200 accounts so the report prints 400 pages, the cover...

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 &quot;-&quot; 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...