Search results for query: *

I am working in CR 8.5 and we have a table which contains the educational degrees a person possesses. In some cases, a person may possess more than one degree, but I am looking for the highest level degree. For example; a person may have a HS diploma and a Bachelor's degree, but I only want to...

I have a formula that I am trying to create. It looks like this: if {HoursPerPay} = '80.00' then '1.00'. The HoursPerPay field is a number field. When I try to check it in Crystal 8.5, I get an error indicating 'a number is required here' and the cursor blinks in front of the '80.00'. Any ideas?

Yes, they are put in specific order. I am not using any groups in the report.

Is there a way to show all of the formulas in CR even if the data is zero? For example, I am doing a termination report for staff by service time. The service time is as follows: less than 3 months 1 3-6 months 0 6 months to 1 year 2 In the sample above, 3-6 months...

Hi, I am using CR 8.5 and I am using a formula in the crosstab to reflect service time for staff. I need to export this to Excel, however the formula does not appear in Excel when I export it. Is there a way to make the formula appear in Excel when I export? Any help would be much...

Thank you very much

I need to split data like this 40/52 39.5/52 37.5/49 into just the first portion of data before the /. I tried using a split function, but get an error saying the result of a formula cannot be an array. Does anyone have any ideas on how I can get around this?

I want to use a formula like this to get {ELeaveofAbs.ulaDateEnd} = null, but I keep getting the error 'a date is required here'. Can anyone offer advice on how to get this formula to work? if{ELeaveofAbs.ulaDateBeg} <= CurrentDate and {ELeaveofAbs.ulaDateEnd} >= 0/0/0 then 1 else 0

()VAL worked, thanks HowardHammerman

Where is the 'data only' option for Excel?

Hi, I have a formula in Crystal 8.5 that calculates annual salary for our staff. Here is the formula: ({EComp.EmHourlyRate}) * tonumber ({@Hours2}) * tonumber ({@Weeks}) The emhourlyrate field is the staff's hourly rate. Hours2 is Left ({@Hours},2 ) and Weeks is Right ({@Hours},2 )...

I need a formula for Crystal for the first of the month following a date. For example, if a date is 12/27/09, the formula would need to return 01/01/10. I have tried several formulas, but keep getting errors. Any assistance would be appreciated. Thanks in advance.