Search results for query: *

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...

I am a somewhat seasone Crystal report writer. I am currently using 8.5 with and ODBC connection to and Oracle DB. I have written a report using the WilePrintingRecords formula set to compare my prev and my next records. The purpose of the report is find where we have duplicate records for...

I am working in Crystal 8.5 with Oracle ODBC connection. I need to compare two records together in the details section and if a record1.field <> record2.field, I want to suppress both records. I only want to show both records if record1.field and record2.field are = to one another.

I am using Crystal 8.5 with and ODBC connection to and Oracle DB. I need to compare a # field on each record and get a list of those records where the # field is the same. I need a report that returns all records where the # field has been duplicated. Subreport, maybe? Is there a way to do...

I am using Crystal 8.5 connecting to an Oracle DB via ODBC.

I have created a formula to find the average of a formula result called @Business Days: Sum ({@BusinessDays}, {LT.COMPANY})/ Count ({LT.APP_NUMBER}, {LT.COMPANY}) I know I can't easily sort by a formula like this in Crystal, but is there a way to get around that? I don't have the SQL...