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 Mike Lewis 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: *

  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

Part and Inventory Search

Back
Top