Search results for query: *

I'm having a strange sort of day and my mind is jumbled. I haven't posted here in years but always got the help I needed when I have posted. I'm hoping for some help again. I'm sure on any other day the solution would come to me but it's just one of those. I have a field which is stored as...

I'm needing to calculate the amount of time that our company trucks are being actively used based off of the driver's actual login times from the dispatch software on their tablets. The problem is the database seems to have multiple records for each time status. I'm not sure why but in the...

I have a report in which I am currently grabbing data in excel and creating a pivot table. I want to be able to skip the pivot table step by using a CR crosstab report. In my rows I have employee IDs . My column is a referencing a formula showing how many of their tickets they have resolved...

I have a report in which I need to round timestamps to the half hour so that anything between 00 minutes and 29 minutes round to the hour and anything between 30 and 59 minutes round to the half hour. So, for instance, 12:00 - 12:29 are in the 12:00 time slot, and 12:30-12:59 are in the 12:30...

How would I go about validating data in a field? For example, I have a field which stores an alpha-numeric value entered by a technician that must match a given format (10 digits long, letters & numbers in certain places within the field, etc.). So an example would be x56kBy67G0. This data...

Hello, I have to pass a field in a report which is a combination of the service ID and Service date. I know that I can remove the slashes from the date field and the decimals from the number field via formatting, but I need to concatenate the fields so that 08/07/2012 1234 becomes...

I'm needing to determine the difference between the time which we promised our service technician would arrive and the actual time by calculating two fields PTime (the Promised time) and ATime (Actual arrival time). Ptime is formatted as a String (5 characters) and is presented like hh:mm. So...

in my table, I have a date associated for each service call going back a good decade or so. I want to compare August performance for just a few years (2009, 2010 & 2011)How would I go about selecting just August records without having to load all of the data between Augst 2009 and August 2011...

I'm told by a coworker than i need this to perform the DateTimeDiff function. I'm using CR 2011 in a Windows 7 64bit environment while he is using CR9 in a WinXP 32bit environment. The directory he said to intstall it in does not exist in my computer. Does anyone know where to install this?

I know this should be easy... I want to find and highlight rows in which there is duplicate data in a specified column. The highlight duplicates does this well, but I am only concerned with duplicates which occur in contiguous rows. Is there a way to only highlight duplicate data in a column...

Hopefully I don't complicate this more than it needs to be. I'm working with a database which, for identity protection purposes, is customer agnostic. I don't have any customer information to uniquely identify each record. What I have been asked to do is to identify service repair records in...

How would I go about having excel randomly divide a list of tasks (abt 20) into randomly selected groups (as even as possible)comprised of a long list of randomly selected people (abt 400? So I want the worksheet to create random groups from my roster and assign the tasks randomly to the...

OK- So complicated for me. Perhaps not for the experts on here. It seems as if you have seen everything under the sun. I'm using CR 11 (not sure it matters here) I have an existing basic if/then in place but the field which I'm looking at is not always populated by the user. Unfortunately the...

I want to display records by half hour increments. So, I want something like this Half Hour Count Met Goal Service Level 08:00 10 8 80% 08:30 18 12 67% 09:00 23 16 70%...

I'm stuck on a SQL statement and am admittedly not a SQL expert. I'm accessing an Oracle DB with MS Access. I want to write a SQL statement to display partners according to the following categories: Preferred: those with whom we have established long standing relationships Standard: Good...

I usually group one of my reports by hour increments by using the hour function (each record in the DB has a time stamp for the service call received time) to determine the number of service items per hour per day of week. However, my boss now wants this done by half hour increments. Is there a...

I've been fighting excel all day and am having no luck! I've ranked our call center employees based off of their service level and have used the percentile function to calculate where each employee falls in relation to the performance of the total group. I want to be able to provide their...

In my DB I have a field that stores a timestamp every time there is a status update to the customer's order. A new record (line of data) is created every time the order is updated. In my query, I have selected the transaction number (35109) and the status code (status_cd)for each time the...

I'm on Excel 2007 and want to insert a calculation into a pivot table. I have been running the calculation in a field outside of the pivot table, but I really need it to be a part of the table so I can sort by the calculated field. Anyway, I'm working with customer service survey returns which...

I have a daily report in which I need to pull a quick report of today's appointments. I have been manually changing the date in the select expert to the current date but I want it to automatically use today's date. I am using CR XI, and have entered the following into the formula editor in the...