Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by csmcvey

  1. csmcvey

    Query Help - Subquery/Exsists/?

    LFC: Thank you for your reply. That query will give me the orders that do have an invoice in a status of closed, but not give me the orders that meet the order conitions and have no invoice that is closed. I need all the orders that meet the order coniditions (o.status = 'closed' &...
  2. csmcvey

    Query Help - Subquery/Exsists/?

    I need help with the following query. I have two tables: 1) ORDERS(columns: fileid(pk), status, office, other fields) 2) INVOICES(columns: invoiceid(pk), fileid, status, date, amount, other fields) I can have multiple invoices for an order. I would like to select all the orders that match a...
  3. csmcvey

    Rolling Report for Last 13 months

    I am trying to create a result set that will tell me how many open orders & the sum of revenue for those orders in inventory I had on the first of the month, for the last 13 months. An open order for inventory purposes are orders that were opened in the last 90 days and not been closed. So for...
  4. csmcvey

    Scheduling Report to Run from DB

    New to SQL SRS - shifting away from CR in our applications. Is the below possible, and if so could someone suggest where to find information in how to implement the solution? We would like to be able to run an already existing report based on a SQL database event. When the event happens it...
  5. csmcvey

    New to CR - Passing Date / Date Range Type Into Report as a Parameter

    New user to CR - still green. We use the Business Objects Infoview Website to schedule CR reports. I have a report called Open Orders. I would like to create one report that I can upload and then when I schedule it, I can pass it a parameter and based on that parameter it will run for a given...
  6. csmcvey

    Toshiba Strata CTX100

    We have a Toshiba Strata CTX100 in one of our locations :(, our vendor is having difficulty delivering what I think is a simple request. Is the following possible with this system and if so, what are we looking at. i have a PRI running into the device and i have 3 fax machines @ 3 different...
  7. csmcvey

    Receiving message - 'The Person You Have Called is Not Available'

    My forward no answer is set to 1638 which is our voicemail #. It is set for 4 rings. This is what is baffling me. Thanks.
  8. csmcvey

    Receiving message - 'The Person You Have Called is Not Available'

    Some of our extensions are demostrating some odd behavior. I am by no means an expert with the BCM200, but I do have a basic understanding. When a DN is on the phone with an outide party and they recieve another call, that new call is receiving a message that states 'The Person You Have Called...
  9. csmcvey

    Hunt Group Overflow to Specific VoiceMail Box

    Thanks for the help, what if we want to use this hunt group to provide backup for multiple lines? Meaning this same backup hunt group would cover a few phones and if the hunt group does not answer the call in the time frame can the call default back to the original line it came in on? I can...
  10. csmcvey

    Hunt Group Overflow to Specific VoiceMail Box

    New user here and I apologize if this is a simple question. We would like to set up our BCM system to do the following: A call is recieved on a Direct Dial line, it is not answered in X rings, it then rolls over to a Hunt Group, if it is not answered in Y seconds the call should go into the...
See more

Part and Inventory Search

Back
Top