Search results for query: *

Hello pmax - That formula does pull the text that I need but it is duplicating the number of records based on the number of lines of text within that particular call. So, if there are 20 other lines of text in this table for this call, it duplicates the call 20 times with one showing the...

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

Thank you for your help. This works perfectly!

The field is last name, first name. Using the formula above I get an error that states: " A subscript must be between 1 and the size of the array." When I click okay, it takes me to the formula and highlights the following section: Split({Customers.Name}, ' ')[2]

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

Thank you all for your help. Converting to Running Totals was helpful and allowed me to get the information I needed.

Hi Charliy, Thank you for the reply. My only issue there is 'Compliance' isn't a field I can summarize in the Running Total. Here is the 'Compliance' formula: IF Sum ({@Count}, {@PresumptiveClassification}) = 0 THEN 100 ELSE ((Sum ({@Count}, {@PresumptiveClassification}) - Sum...

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

Hi Brian, This works great! Thank you so much for your help. It's greatly appreciated.

IF {@SuppressionFormula} = False then 1 else 0 Yeah, it's weird to me too as to why it's not allowing me to summarize from this point.

Yes, I already had that formula created but I still do not get an option to summarize that field.

Well, I should also add the formula used to suppress doesn't show as one that can be summarized.

Thanks for the help Briangriffin - I did get the true/false to return but I do not have the option of inserting a summary into the group footer. Report footer is the only option it gives me.

It tells me the 'the keyword "then" is missing'.

Thank you for the response. Unfortunately, this doesn't work as the suppression formula isn't as simple as just turning it into an IF/THEN statement.

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

Hi JetRamsey, I use Crystal to extract my data, export it to Excel and then use the website http://www.earthpoint.us/ExcelToKml.aspx . This website is an Excel to KML converter and works great. The website also gives you information on how to add additional columns and make your data even...

Hi Charliy, Thank you for you response. I have tried the running totals but they do not come out accurate and I have tried every possible combination for 'Evaluate' and 'Reset' and the numbers do not add up like they should.