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 John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by samiam2006

  1. samiam2006

    Books, Websites, and tutorial links

    Another source for live classes is www.visionharvest.com Their class manuals are also excellent self-paced and reference manuals.
  2. samiam2006

    Displaying part of the record selection criteria

    You need to convert the dates to test. Try it in this format. "From " & ToText(minimum({?DateRange}),"mmmm d, yyyy") & " To " & ToText(maximum({?DateRange}), "mmmm d, yyyy")
  3. samiam2006

    Using zero in DateSerial

    In case anyone cares, this also works in Excel. =DATE(2006,12,0) yields 11/30/06
  4. samiam2006

    Using zero in DateSerial

    It works in Xi r1 and r2. I've usually done it the second way you have listed. This is a nice short cut. Thank you
  5. samiam2006

    CRXI: change Group name if on second page

    Sorry I meant "page 2 or more
  6. samiam2006

    CRXI: change Group name if on second page

    The basic formula starts with: If InRepeatedGroupHeader Then .......... This is only true if the group goes on to page 2+.
  7. samiam2006

    Oracle report conversion

    I'll agree with you about the Oracle SQL. I'm in the process of converting a number of very complex Oracls reports to CR and it's been a painfull and slow process. I've takent the Oracle SQL and added them to each of the CR reports as commands. After I figure out which ones are used for a main...
  8. samiam2006

    Using MySQL date fields in Crystal Reports XI

    Since we're in an environment that is locked down and doesn't allow any non-approved software, I came up with the following formula: DateTime(1970,1,1,0,0,0) + ({#_of_seconds}/86400) It converts the #_of_seconds to days and a time fraction.
  9. samiam2006

    Difference bewteen CE and BO

    synapsevampire I agree with your assessment of the BO world and am looking forward to see the progress of MS Reporting Services, ActiveReports, LogiXML and some others out there. The big advantage/downfall of CR is that the average user with a minimum of database/programming/design...
  10. samiam2006

    Starting With Crystal Reports

    Check out www.visionharvest.com They have an excellent intro course (book and/or class) and www.kenhamady.com has some great resources
See more

Part and Inventory Search

Back
Top