Search results for query: *

I couldn't figure out how to use this with the formula; however, I was able to format the fields correctly, after I changed them from a strings to numbers and the result works for us. You're awesome...thanks!! Jan

Sorry, I am really trying to be clear...what I am trying to say is that the report cannot display .0 decimals. If the values for measure 1 and measure 2 are: Current This is what I need: 98.6 98.6 106.4 106.4 90.0 90 25.2 25.2 87.3...

I need to remove the .0 decimals from my report. The measure 1 and measure 2 string values can be for example 98.0 and 98.6. If the value is .0 I need it removed; however, if it is 98.6 I need it to show the whole value. What I am looking for is either 98 or 98.6. Hope that makes sense and...

OK, I am going to try your suggestions now. Someone here thought they had come up with a different solution but that didn't work so I am back at it. Thanks so much for your time! Will let you know and give you some Stars if I can.

This is a very small sample. The report is grouped by Attributes and I need to display the first and last record of each attribute according to date/time it is recorded. ATTRIBUTE (1) Measure1: 98.0 Date/Time: 9/24/200 13:46 Measure2: Recorded by: Test,Jan Measure1: 97.0...

Sorry I wasn't clear, I do mean that after using the above formula I still have multiple records but only want the first and last of what remains? It is a date/time that indicates the order.

I can't say that I am new anymore but I still have trouble with formulas! I have a suppression formula in a report that looks like this: {pry8_flowsheet;1.report_section} <> '100_phys_attributes' and returns multiple values. Of these values I need to suppress all but the first and last...

I need to add the dayofweek and abbreviate the month in this formula - I need the date to display as: Thursday, Aug 30, 2007. Any help would be greatly appreciated! The formula is: Dim DateField as DateTime Dim MM as String Dim DD as String Dim YYYY as String Dim DATEORDER as String...

That worked...thanks so much!

I a writing a Crystal Report where I have a LAST NAME field and a FIRST NAME field. I need to have it show on the report as last name first initial, like SMITH J with just one space between the last name and the initial. This seems like it should be easy but I just can't figure out how to do...

Hi, I have a page header that needs to be suppressed when a user answers a report prompt as 'Discharge' and I use this in the Section Expert Suppress formula: {?Discharge or Transfer} = 'Discharge' However, if the user answers the prompt as 'Transfer', I need the page header to print only on...