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?

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"?

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

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

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.

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

I have a report that I have put whileprinting formulas in to get the last two net worth reports for each company. Group = Company and is returning company name and last net worth $ by company Details = last 2 net worth by company, but only previous to last $ is displaying. In the group =...

I have created a report and used the following formulas to get the top 2 records for each group. Formula 1 - whileprintingrecords; numbervar RowCount:=0; Formula 2 - whileprintingrecords; numbervar RowCount:=RowCount+1; Now that I have those top 2 $ amounts, I would like to get the difference...