Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jp3333
  • Content: Threads
  • Order by date
  1. jp3333

    Formula help to remove decimal, Crystal 10

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

    Suppression formula help please - Crystal 10

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

    Date format assistance please

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

    Help with name format Please

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

    Suppress section formula question?

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

Part and Inventory Search

Back
Top