Recent content by demchak

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