Search results for query: *

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

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

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

I am trying to schedule a report in CE9 and I get the following message when trying to run the report. "The report you requested requires further information." "Database Logon" and gives me a username/password box. It is showing the Server name and Database name which are correct. A coworker...

I have a report that basically gives the details of a helpdesk problem ticket. I am trying to get the age(time) between the {TABLE.OPEN_TIME} from Group #1 and the Datestamp from the first record in Group #2 that has the activity type of "Comm with Customer". I have a formula that gives me the...

Hello, I have a field that produces a string with a "from" and "to" group imbeded in the text. I would like to have two seperate formulas that extract these group names from the current string. One formula for the "from" group and one for the "to" group. The example below is exactly how it...

I have several reports that I am trying to deploy to a few managers and they are wanting to see these reports in daily, weekly, monthly, year-to-date, ect.. I tried to create a parameter field that points at the {TABLE.OPEN_TIME} and I create a pick list with the syntax.. LastFullWeek...

Is there somewhere I can download a demo of Brio from?

I have a crosstab report that shows the number of helpdesk issues resoved by group and by the age. I would like to get cumulative totals instead of the accual count of issues resolved and have it displayed as a percentage. This is what the current report produces: >1 Day | 1 Day | 2...

I am trying to extract the area code from the phone number in our contacts table. The problem is that due to poor data entry, the field does not have a standard format. We have told our tech's to imput the phone number in the format XXX-XXX-XXXX but of course it is not always done correctly...

I have looked through the threads for this issue and have found a few formulas that help but I am still running into a problem. In my report I have a formula (@TimeDiff) that gives me the DateDiff in seconds of the {TABLE.OPEN_TIME},{TABLE.CLOSE_TIME} then I have a formula (@AverageAge) that...

I have a report that is count the number of tickets based off of {TICKET.OPEN_TIME}. I would like to use a cross-tab for this report. I have started a formula to split the count up by day, WTD, MTD, and YTD, the problem is that when it counts a ticket under MonthToDate, it does not count it...

The goal of my report is to tell how many days it took a technician to contact the customer. I need a variance of days between the Open Time of the ticket to the First Customer Contact (which is stored as an activity in the ticket with a date stamp). I am thinking it is going to require a few...

I have been working on a commercial job that is larger that I have done in the past, and in pulling the CAT5 and CAT3 I have been commming up with to much extra cable when I cut it. Does anyone have techniques that they use to run cable? (i.e. put the cable boxes at te jack or destination? I...

Is it possible to delete a registry key that will in turn remove a dialup entry in the "network properties" section in windows 2000? I am trying to built a small util that will remove a troublesome netowkr entry. This dialup entry is something that is created everytime our employees...