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!

  • Congratulations TouchToneTommy 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: rhammond
  • Content: Threads
  • Order by date
  1. rhammond

    Average of a Group Formula Field

    Here's my issue: I have a report where Group 1 is the Date, and Group 2 is the time. I've got a field where in order to get the data I need, I create a sum of this field (represents a value in seconds for the record) in Group 2, suppress it, and then have a formula that is displayed (Sum...
  2. rhammond

    Convert Seconds to HH:MM:SS format

    I have a field where I have a time value that is displayed in Seconds. I need to display it as HH:MM:SS. I've been looking and looking through the help text and the knowledge base on Crystal's site, and can't find anything...anyone know how to do this?
  3. rhammond

    Display last month's date value in report header

    I'm trying to display in the header of my report the value for last month (in the following format - "December 2002"). How can I do this, especially since I'm not actually reading this value from a particular database value?
  4. rhammond

    Use formula fields across reports?

    I have several formula fields that I've constructed that I will use on many reports. Is there an easier way to insert them into a new report other than opening another report that has them, then copying/pasting? Perhaps there's some sort of tool for "sharing" them across reports...
  5. rhammond

    Strip "DE_" prefix to field names when export CR to Access?

    Is there any way of stripping out/preventing the prefix of "DE_" being added to my column names when I export a Crystal Report into Access via ODBC? Thanks, Rebecca
  6. rhammond

    Subreport not saving with primary report??

    This has happened to me a few times now...I have my primary report, and I've attached a sub-report to it (not creating a new one, but attaching a separate report). I make changes to both the primary and sub reports, I save and close the primary report, and when I re-open the primary report, the...
  7. rhammond

    Null Values in Concatenation

    Here's my problem: I have 3 fields I'm trying to concatenate in a formula field. My syntax: {field1} + ", " + {field2} + ", " + {field3} However, there are some cases where Field 2 or Field 3 are null, but I still would want whatever wasn't null to appear. Any ideas?

Part and Inventory Search

Back
Top