Recent content by OKCMikeSoll

even better.. =) thank you LB

I figured it out just after I posted. The answer was right in front of me and very simple. Here's what I did: if dayofweek({hvdn.row_date}) = 1 then "Sunday" else if dayofweek({hvdn.row_date}) = 2 then "Monday" else if dayofweek({hvdn.row_date}) = 3 then "Tuesday" else if...

Hello everyone, I'm trying to report on the number of calls that arrive by interval for each day of the week. The data is stored by interval so I was trying to group by {table.interval}. I need the columns to be a sum for all calls for that day of week over any given period of time(i.e. last...

Hi Everyone - I have seen posts related to my issue but was unable to "reverse" the logic to fix my issue. I am trying to strip the domain name from an email address. Current: my.name@mycompany.com Want to return: mycompany.com The current formula I have is as follows: ToText...

Any ideas?

It apears to display all activities associated with the Ticket Number(GH1) but it create duplicate records and they are no long sequential. For example: Ticket Number G1: 123456 Activity Num Type Date Stamp D: 1 Ticket Open 1/1/2005...

I was grouping on the activity number becuase they are related to the incident number and are sequential. It may be the wrong way to go about it but it is basically replicating a ticket with all history from that ticket. I have nothing the in the details section. -Mike Soll

If there is a thread that will answer this question please let me know which. Otherwise, I am tring to get aging information from 2 date/time fields. I have formulas to calculate the age but the challange for me is trying to select a specific date/time record base on criteria from another...

I spoke with our WAN team and they are not blocking your site. They can see the traffic leave our firewall but it is not returned from your site. Is it possible that our company may be blocked on your end? I have IP addesses for you to check but I would like to contact you another way to give...

Thank you for trying.

I have been directed to www.MilletSoftware.com for a solution to the problem I have been having but the site seems to have been down for the last couple days. Is anyone else having this problem? If so, Is there another source for that software? Thanks, Mike

I am using the function listed below to convert my date/time fields to Central Time and it works fine. The problem is that when it adjusts for DST it bases that off of the date from the PC that is running the report. I need it to look at the date value of the database field and then at that...

I currently have a variable that gives me the total number of seconds between two dates, but I cannot find a function to convert the total number of seconds into the format H:MM:SS I searched the posted and did not find anything out there. If anyone has any suggestions I would be greatful...

synapse- I can get more accurate results if I get the datediff in seconds and then convert it to dd:hh:mm:ss. If I use datediff in days then convert to seconds it will could possibly be way off. Do you have any ideas on this? Or, Can you divuldge a little further on your "table driven...

I am using CR 9 reporting on an oracle database. I have a report that is calculating the average open time of helpdesk tickets that are in an open status. Listed below are the formulas I am using and they are giving me the correct average age but the average age includes the 48 hours from the...