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!

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

Search results for query: *

  1. MiagiSan

    Formula Help with Grouping data

    Thank you CoSpringsGuy, I think I have it now finally. :-) MS
  2. MiagiSan

    Formula Help with Grouping data

    Hello, I am using CR 2008 with an SQL DB. I am tying to create a report that shows where in our organization a case was resolved. -Tier 1 -Tier 2 -Outside Support (Dev, Engineering, etc) Some background information. A case will always be touched by a Tier1 as the initial contact. A case...
  3. MiagiSan

    Record Select Question

    Perfect!! Thank you!!
  4. MiagiSan

    Record Select Question

    Hello, I am using Crystal 2008 with an SQL database. I have created a report from our CRM system that shows a listing of escalated "Cases". Case ID Name Description 12345 John Smith Test1 67890 Johnny Smyth Test2 What I am trying to do is be able...
  5. MiagiSan

    Desktop Messaging Issues

    Yes I did, please see below. (I am not sure what to look for) This trace begins with receiving a message, playing it and then attempting to delete. Thanks for the assistance! 13:18:59:993 - CallPilot 05.00.41.142, Copyright 2011 Avaya Inc. All Rights Reserved 13:19:10:353 [1056, nrm...
  6. MiagiSan

    Desktop Messaging Issues

    Perfect! Will do Barnie, thank you!
  7. MiagiSan

    Desktop Messaging Issues

    Thank you for that information Barnie, I have tested it a number of ways including emptying the "Deleted Items" folder. Each time I have listened to the message first. I also noticed the Edit option in the player gave me an option to "Mark as Unread" which tells me the message has been read...
  8. MiagiSan

    Desktop Messaging Issues

    Thank you Barnie, It is true Desktop Messaging. (I had to install the client software to intergrate with Outlook) I have been reading through the documentation and it "seems" like I have to also have "My Callpilot" installed as well. I noticed a spot for the "My Callpilot" URL in the Message...
  9. MiagiSan

    Desktop Messaging Issues

    We just upgraded to a new switch. (Avaya CS 1000) and Call Pilot 5. Desktop messaging has been activated however after I listen to the voicemail through Outlook, the Message Indicator light on the phone continues to blink and the CP MWI icon (on my PC taskbar)says that I still have a message...
  10. MiagiSan

    Calculation Problem between Main and Subreport

    Thank you lbass, I will give that a try. Have a great weekend. R
  11. MiagiSan

    Calculation Problem between Main and Subreport

    Hello, I am using Crystal 10 and I am having a bit of a problem with a report. I will try to explain as best as possible. I am sorry for the length of this posting. The Main Report has a number of Cross Tabs in the header area and a section that shows me the following. Total number of cases...
  12. MiagiSan

    Excel 2007 - Time Schedule Question

    Thank you very much!!
  13. MiagiSan

    Excel 2007 - Time Schedule Question

    Hi Everyone, I have a staff schedule presented to me in Excel. (I am using 2007) A 1,2 Merged (Person1) A 3,4 Merged (Person2) B1 - 9:00AM (Start of shift for person 1) B2 - 5:00PM (End of Shift for person 1) B3 - 10:00AM (Start of Shift for person 2) B4 - 6:00PM (End of Shift for person...
  14. MiagiSan

    Aging Buckets - Days

    Perfect!! Thank you lbass and everyone!
  15. MiagiSan

    Aging Buckets - Days

    Thank you to both! I tried kskid's suggestion first as it looked the easiest. The formula works without this: {STATUS_TBL.STATUS}<>"CLOSED" and but when I add this to the formula, I am being asked for a boolean I tried tweaking the formula but it is still not working. I think I am much...
  16. MiagiSan

    Aging Buckets - Days

    Hello, I am using CRX with SQL and I am trying to add a cross tab to my report with the following information. For tickets that are not equal to "Closed" 1-3 Days old 3-5 Days old 5-9 Days old > 9 Days old I found this posting by LBass a while back but the "aged0to30days" formulas do not work...
  17. MiagiSan

    Data not showing up - Join Issue?

    I am not sure if I am allowed to swear on this forum but... Holy $hit, it worked!! Thank you Ian R
  18. MiagiSan

    Data not showing up - Join Issue?

    Hello, I am using CR X and I have 3 tables in my report. TableA is left joined to TableB by {CASE_ID} TableB is left joined to TableC by {SOLUTION_ID} (TableB and TableC are solution tables) Currently My data looks like this in my report. Case ID Status Customer Solution 123456...
  19. MiagiSan

    Question on missing data

    That did it!! Thank you very much!! R
  20. MiagiSan

    Question on missing data

    CR 10 SQL Hello, I am pulling data from my CRM ticketing system to show me the following data: Case# Name Company Status Summary Solution 12345 Jsmith ACME Closed xxxxxx xxxxxx 54321 Rsmith IBM Closed xxxxx xxxxx The issue I am...

Part and Inventory Search

Back
Top