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 Rhinorhino 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 OldGrayMare

  1. OldGrayMare

    Date/Time Error for Parameter Date Range

    We use Crystal 11 Our dates are stored as Date/Time values. I have created a date range parameter, selected Date for the Type and Allow Range Values for Options. When I run the report, I get no data and an error like "Field requires a date/time value". I tried converting the date/time to a...
  2. OldGrayMare

    Excluded Field Criteria also Excludes Nulls

    CRYSTAL 11 We have Products broken down by Model/Version. Some of our NCID Product Model/Versions are blank. I am attempting to print all records that have the Product Name of "NCID" where the Product Model/Version does not include "NG". In other words, I want all NCID Product Names where the...
  3. OldGrayMare

    Records Between 5:00pm and 7:00am

    Thank you, Mr. Bass! You really ARE a genius. This solution works perfectly. [bigsmile]
  4. OldGrayMare

    Records Between 5:00pm and 7:00am

    Crystal XI = Version I have a datetime field (SubmitDate)and need to select records in the last 6 months with a SubmitDateTime after hours, that is from 5:00 p.m. until 7:00 a.m. How do I select that 5:00 p.m. until 7:00 a.m. timeframe? Thank you!
  5. OldGrayMare

    Print Record if the First 15 Characters Match

    Hi, Brian: Thank you for your formula. I changed it to: Left({SIT_Site.Site},15) I am getting the 1st. 15 characters of all site records, but I only want the site records where the 1st. 15 characters are duplicates. It seems I need an IF in there somewhere, and perhaps a DO While Printing...
  6. OldGrayMare

    Print Record if the First 15 Characters Match

    I am using Crystal 11. I have a table called SIT_Site that contains the field called Site. I need to create a report that compares the 1st. 15 characters in the SIT_Site.Site field and only prints duplicates (the records where the 1st. 15 characters match). How would I accomplish this please...
  7. OldGrayMare

    Including 2 NULL Fields in Selection Criteria

    THANK YOU, -LB!!! This works! Do you know of any white papers that explain in laymans terms about parenthesis use rules in Crystal? I just don't understand how to use parentheses.
  8. OldGrayMare

    Including 2 NULL Fields in Selection Criteria

    I tried the suggested formula but get an error: "The remaining text does not appear to be part of the formula." This is the selection criteria I pasted that is giving the error: ) //The above gets only NULL or Blank records then // then,the section below adds further criteria for these...
  9. OldGrayMare

    Including 2 NULL Fields in Selection Criteria

    I use Crystal v11. I want to see all records where either the product name or the closure product name are blank and the records also meet the other criteria. When I use the selection criteria below, I get all records, even those whose products are not null. IsNull ({HPD_Help_Desk.Product...
  10. OldGrayMare

    Days Open (DateDiff) for Null Dates

    I found this suggestion on another post: IF isNull({HPD_Help_Desk.Last Resolved Date}) THEN DateDiff ("d",{HPD_Help_Desk.Reported Date} ,date(1900, 01, 01)) ELSE DateDiff ("d",{HPD_Help_Desk.Reported Date} ,{HPD_Help_Desk.Last Resolved Date} ) // date(1900, 01, 01) I tried that, but I am...
  11. OldGrayMare

    Days Open (DateDiff) for Null Dates

    Thank you, FISHEROMACSE. When I use the "", however (see below formula), I get an error: "A date-time is required here." I really appreciate your work on this, and will continue to check back for updates. OGM
  12. OldGrayMare

    Days Open (DateDiff) for Null Dates

    Thank you, FISHEROMACSE. Logically, this should work and produce the actual days open for unresolved tickets. However, after making these changes to the report formula, I still get zero (0) for days open. I did make one minor change to your formula as indicated below, since this is a...
  13. OldGrayMare

    Days Open (DateDiff) for Null Dates

    Using v. 11 I have a report that shows days open for tickets based on the formula below. Some of the tickets are active, however, not having a Last Resolved Date. Those are currently showing zero (0) for days open (report line below -- see 0 after the date/time on first report line). I want...
  14. OldGrayMare

    Print "No records for the current month." for Blank Report

    THANK YOU, LB! I do like your way better.
  15. OldGrayMare

    Print "No records for the current month." for Blank Report

    In my continuing search for the answer to my problem, I got it solved, so please disregard my request unless you have a better or easier method than this: I created another Page Header section and conditionally suppressed it this way: IsNull ({HPD_Help_Desk.Incident Number}) = False
See more

Part and Inventory Search

Back
Top