Search results for query: *

When a file is exported from Crystal Reports to Excel 2002 and then opened in Excel 2002. Excel gives the error, RENAMED INVALID SHEET NAME. Excel repairs the file and then allows me to open the file. Why does this happen? Thanks

Thanks Naith, I see where the statements are testing if it's Monday, but how does Crystal know to only pull records from the last business date? When I read this statement it looks to me like Crystal is going to pull all records where SubsidiaryCode = "IMD" and swGroupName =...

Thanks again, I am getting ready to try synap's code now, but in the meantime I have another question. Someone at work used the following code. I would like to understand how it works but she cannot it. This report is only run during the week. If DayOfWeek(CurrentDate) = 2 and...

Thanks to both Naith and synapsevampire. I tried synapsevampire's suggestion but am getting a date-time is required error at maximum in the formula. Should I have put in something else? Thanks

I'm new to Crystal Reports and am having problems creating a formula that pulls records from the last business day. The date field in the table I'm pulling from is formatted: 02/01/2002 03:02:11AM The formula I tried to use is: IF dayofweek (CurrentDate) = 1 Then CASE.swDateCreated =...