Recent content by mocgp

Yeah, what Ian said. The reason you are getting an extra count is that your formula doesn't specify a THEN clause. If the DischYear = "0708" then you are getting an Encounter # and those are being counted. But if the DischYear is not equal to "0708" then you are getting a blank (or a null)...

For Excel - Data only, another option is to create a separate header (page header or report header) for each of your rows. In your case, header row 1 would contain the text "REC" in column 4; header row 2 would contain the text "SHORT" in column 2 and "CHANGE" in column 4; header row 3 would...

OK, that works except for one slight difference. My code changes the date on the Friday after the first and third Thursdays, your code changes the date on the the Friday after the first Thursday but then changes on the Third Thursday instead of the Friday after the third Thursday. If you can...

Still doesn't work right. I think what you are failing to take into account is that there can be 5 Thursdays in a month (ex., Apr, Jul, and Sep of this year). Your code lines up with mine up until the end of July then returns 8/19 on Aug 1 when it should be 8/5.

Ian - I plugged your formula into my query that hits a static date table and compared it to the results of my formula. Your formula does not match up; it seems to change the date on various days of the week instead of Friday (when it is supposed to switch to the next nearest first or third...

Wallie12 - Thanks for the response but I'm afraid that you missed the question entirely. I arrived at a solution a few days after posting the question. The required formula is - DateVar dte:= Date({DateField}); NumberVar DayOfMnth:= Day(dte); NumberVar DayOfWk:= DatePart("w",dte,crThursday)...

Using BOXIR2; Oracle 10 Using a given Date field, is it possible to create a formula that will return the date of the next nearest first Thursday of the month or, if the given date field is already past the first Thursday, then the third Thursday?

Ken: I managed to get a table (Oracle) to update from one report by using subreports containing the chunks of SQL that would not work with a ; separator. In other words, the main report conatined the SQL command DELETE FROM... , the first subreport contained the INSERT command and the...

If I'm reading this correctly, you need to create a group for Year, one for Semester, one for Class, and one for Section. Then you can right-click on the Student_ID field (which I take to be a count of the enrollments) and create a Summary for any or all of the above groups. Change the Summary...

Thanks for the suggestion; probably should have realized that when I narrowed the scope to Enterprise. I learned after the post that they now suspect hardware and are changing out some disks this afternoon. I still posted the question in the CE forum just for grins. I am assuming from your...

Using BOEXIR2 Our underlying data platform was recently upgraded from Oracle 9i to 10g. Since the upgrade, we have had numerous performance issues with Crystal Enterprise. It is thought that the issues are within Oracle itself but I am curious to know if we should have expected this change to...

Using BOEXIR2 Our underlying data platform was recently upgraded from Oracle 9i to 10g. Since the upgrade, we have had numerous performance issues with Crystal Enterprise. It is thought that the issues are within Oracle itself but I am curious to know if we should have expected this change to...

I have since discovered that the Font list filter is available but only if you right click and select the Format Field option, then go to the Font tab. Not much consolation since that's 3 times as much work as using the Font toolbar list. I still tend to develop in 10 and then save in XIR2...

There's not quite enough information here to be very specific. It would be helpful to know which version of Crystal and what type of database is in use. We also need to know how your 2 Running Totals are structured. If I assume that you have a valid {lab_rework.rework_date} for each row that...

Perhaps I missed something in translation but that's what a left outer join does - "Show me ALL the records from table A and ONLY those records from table B and C where the joined field is equal." If that was your intended logic, then I don't see that you have a problem. The null value doesn't...