Recent content by vblack7770

Is there a conversion tool that is proven to convert Crystal 8.5 .rpt files to Crystal 10 or Crystal 11 files?

I am using CR 8.5 with an ODBC to the database. I would like to write a formula that would help me count the digits in the social security # field and return all records that have > or < 9 digits. Thoughts?

DUH!!!!! Oh my!! Thank you......I knew I was making it too hard....I need more caffiene.

I am using CR8.5 with and ODBC connection to my Oracle 9i DB. I would like to do the following and am finding it impossible in Crystal. Can I do this in Crystal, or do I have to create a view on the DB side? Generic Explainatin: Pull all loan records and their detail fields that = value A...

Why do some people use "irregardless" in place of "regardless"?

Oh!! I figured out what you meant. Thanks loads for the help as usual!!! :)

Returning the # of days between two days is not what I needed. I actually want counts for the following: How many business days are in the Month(currendate)? How many business days are left in the Month(currentdate)? How many business days have passed in the Month(currentdate)?

I am an experienced crystal user. Developing in CR 8.5 with Oracle ODBC connecting to Orace 9i DB. I am working on the following: How many business days are in the Month(currendate)? How many business days are left in the Month(currentdate)? How many business days have passed in the...

Sorry, title should be Combining Days of Week records.

I am using Crystal 8.5 with a Oracle ODBC connection - Oracle v9. I am working on a report that will be pulled daily and give the count of total records in a group by day. I am using the DayOfWeek({table.date}) formula to get the 1 thru 7. How do I go one step further to obtain the records I...

And that is exactly what I need. These date represent stages of a file. If the first date is populated and none of the others are, then it would go in the first group and so on. However, some date fields will not be populated as a file may skip a stage. Does that make sense?

So the test for null would have to be outside of the selection criteria as a seperate formula and then I would base selection criteria off the formual?

I am using Crystal 8.5 with a standard ODBC-Oracle connection. I have a simple report to pull in records, group them and then count/sum them. When I use the following selection criteria: {LT_MASTER.APPLICATION_DT} in MonthToDate or {LT_MISC_INFO.USER_DTS##1} in MonthToDate or...

Crystal 8.5 with Oracle ODBC connection, XP. I am trying to retrieve all records that meet the following criteria: One year ago today Example: 09/28/05 - I would like all records for 09/28/04. (CurrentDate-365) doesn't seem to work.

They may be considered duplicate because only some of the files match, not all. There are several combinations. Example: Test 1 - borrower name, property and lien position match or Test 2 - borrower name, property and loan amount match or Test 3 - property, lien position match etc., So, I...