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 Chriss Miller 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: kridg
  • Order by date
  1. kridg

    Specific Sorting by common beginnings

    I've used the specified sort with dates since our database stores them as YYYYMMDD. I want list files by their date in decending order. Using the specified order, I create a group named "Year 2001" and the criteria is that DATE "startswith" 2001.
  2. kridg

    GW5.2 and Win2000: Words being replaced automatically

    The problem began when we installed new PC's running Windows 2000 professional, still using GroupWise 5.2. The user will type a message, and intermitently GroupWise will replace words with something else. There is no consistency to what letter or space combinations are replaced, but the...
  3. kridg

    Use 2 Excel files to create 1 report

    Is there any way to use 2 (or more) separate Excel (.xls) files to create 1 Crystal Report Version 8 report? The main Excel file "Projects" contains a column with an identifier for each row; The second (and other) Excel files have a similar column that contains the same project...
  4. kridg

    Export reports to HTML? You may owe $10K per year.

    I have spoken to Crystal Decisions reps twice today, and am more irritated now than when I started. It is still about as clear as mud. I suggested that they make an effort to provide a clear explanation so that they wouldn't be getting questions. The response was less than acceptable...
  5. kridg

    Messages auto-deleting

    Thanks, but I already did. I've checked every setting under Options for that user.
  6. kridg

    Messages auto-deleting

    Two weeks ago, the user had several hundred sent items, and her incoming mail was either in her in box or was in the cabinet. Last week it disappeared. She has about 20 items in her Sent folder, all from the 18th or later. I've checked rules, cleanup, and filters. This has now happened to...
  7. kridg

    Want to print out all formulas

    Works perfectly in Version 8 also, thanks very much.
  8. kridg

    seagate crystal reports

    My database has the date as a string, formatted as yyyymmdd. To do a date calculation, I needed to change the string to a number, then change the number to a date. DATE(ToNumber({Query.RECDATE}[1 to 4]),(ToNumber({Query.RECDATE}[5 to 6])), (ToNumber({Query.RECDATE}[7 to 8])))
  9. kridg

    Want to print out all formulas

    Is there a way to print out the formulas that are used in a report? I know I can open each, copy and paste it to a Word document. I was trying to find a shortcut that will print them out for documentation purposes.
  10. kridg

    CR Performance :(((

    We have more than 6,000,000 records on our AS/400 database, so I have to be very careful of my initial query criteria. One of the worst is a monthly report that originally used 800,000+ records yet only produced totals for 5,000. Once the query was refined, the 3 hour query took 20 minutes...
  11. kridg

    Date Formatting

    I have the same problem with a database that stores the date as a string, and then in the format of YYYY-MM-DD. I use this formula to reformat it (still as a string, date calcs won't work) but puts it into MM-DD-YYYY. ({Query.ActionDate}[6 to 7] + "-" + {Query.ActionDate}[9 to...
  12. kridg

    URGENT: Count # of business days elapsed

    The database stores the date as a string ("19910731"), and (thanks Malcolm!) I was able to convert the string to a date value. Now I need to count the number of days that have elapsed since the case was opened, but have to exclude Saturday and Sunday. If the CurrentDate is...
  13. kridg

    Formula Fields

    Have you tried the isnull function? If isnull({db.FieldName}) = True then ...

Part and Inventory Search

Back
Top