Search results for query: *

I'm trying to extract certain characters from a 'Description of Transaction' window that shows all activity that occurred in an ambulance call - such as: Call Taken, Assigned to Vehicle X, Response Priority, Time unit went enroute, at scene, etc. It also has line items for a certain piece of...

Hello all... I've got a chart in Crystal that displays average time spent at a hospital by day. I would like to highlight certain dates (custom list) during this period and want to know if that's possible without manually adding colored boxes around the dates since I would have to do this to...

Using Crystal XI with an ODBC database: I have a customers name field that displays full last name, full first name. I only want the customers full last name and the first initial of the first name. I have a working formula to just trim the name -3 characters but for long names, you can still...

Hello all, I am trying to calculate my compliance percentage (Compliance) by month but I only want to see how our first TEN days of the month have been historically. I also want to see how many total calls were received during these first ten days also just for comparison purposes. My current...

I have scoured the internet searching for the best suppression formula to use here and I have been unsuccessful. I am trying to suppress the GH when the Details section is suppressed based on already used suppression formula in the details section. I have a customer (patients) report that...

If there are any braniacs out there who can help me figure out how this information is obtained, it would be greatly appreciated. The following screenshot is an Excel spreadsheet that was created by a former employee. He would run this data through some other database or query and extrapolate...

Hello all... I'm back again. I need your expertise in getting this report corrected. I am trying to take a trending report that shows the number of ambulance calls for a given period and shows a YoY comparison of those responses for that specific response zone or contracted area. I have...

I have searched the forums and read numerous threads but none that seemed to help me with a report I am working on. I am an administrator with an ambulance service and I am trying to trend the number of late calls we have on weekends versus weekdays and want to show that in text form and then...

Hello all... I have a report I created and I'm having a problem with being able to select a formula to drill down the report into the data I want to see. I have a formula "LateFlags" that is a number and "LateFlags_True" that is a string. Neither of these show up in the "Select Expert -...

Good Morning all, I am trying to calculate my ambulance service response compliance percentage using Crystal XI w/ an ODBC Database. I already have a report created showing response times (which is a formula and showing an average response for each city/county in the Group Footer). I'm not...

Hi All, I am working on a report where I am trying to calculate patient's age and my age data (DOB field) is a "string" field. I have tried the Ken Hamady formula and it tells me, when inputing the "Customers.dob" field that a "date is required here." How can I get this formula to work or...

Hi All, I am running Crystal XI w/ SQL. I have a report I have created that pulls calls where an ambulance responded to a residence two or more times within a week (7 day period). For these records, I would like to create a "DateDiff" formula that will allow me to restrict calls that show...

ODBC - CR XI I am needing to create report that pulls the date ranges where the first Monday of the month is the focus. However, I need the date range to pull the Thursday prior to the first Monday of the month. Along with that, even if it is a seperate formula, I need to show a comparison...

Hi All, I'm using Crystal XI and I have a formula in a column that subtracts a units time they have spent at a certain location from the time they were sent to that location. If a unit never arrived to their assigned location, the report returns a zero. I want to create a formula that...

I have a time field that adds two time fields to equal a total elapsed time. Out beside the total time field in a seperate field is a formula that indicates whether that call occurred during "Shift 1" or "Shift 2". My question is, what would the formula be in the GF that would average the two...