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

    Editing a SQL Query - Adding new Fields to a Report

    I am currently using a Crystal SQL Query Designer QRY file as the datasource for my Crystal Report. (Not sure if this matters, but I enter the SQL statement manually rather than using Crystal's table linking tool.) I found that if I need to edit the QRY file, i.e., add additional fields to...
  2. christinh

    Convert String to Date where invalid dates exist in DB

    Thank You! It worked great!
  3. christinh

    Convert String to Date where invalid dates exist in DB

    If the month is unknown, January would be fine. If the day is unknown, the first of the month. If both are unknown -- Jan., 1st. (The year is always available.) This is really stumping me. Thanks!
  4. christinh

    Convert String to Date where invalid dates exist in DB

    I am trying to convert dates stored as strings to a crystal date format. The problem is that the database I am using allows invalid / partial dates. For example, there are several records in my database that have a date of 19000000(year 1900 but the month and day unknown -- the month and day can...
  5. christinh

    How do I "Count If" in Crystal

    ThanKs Malcom & MALK
  6. christinh

    How do I "Count If" in Crystal

    I am trying to count the number of times a particular string appears in a field on my report. For example, I have an orders table and I want to know how many times customers from FL placed an order. In MS Excel, it's so simple "=CountIf(Range, Criteria)". I've tried using the Crystal...

Part and Inventory Search

Back
Top