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.
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...
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...
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...
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...
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])))
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.
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.