Search results for query: *

I am trying to convert a date field that is stored in the AS400 as a numeric field. The data is YYYYMMDDMMSS. However, when displayed in Crystal 10 or 11 is shows commas in between for example 20040120.00. The formula I am trying to use is as follows: NumberVar input:={CKSCHEDE.SEFRDT}...

I am trying to create a report that only shows employees that have mutiple checks for a given pay date. Any help would be really appreciated.

Yes & No. Basically, in order to get accurate numbers I had to add a footer and sum all the records. The derived fields did not work correctly. According to ReportSmith tech support, they indicated this was the way to do it. However, I never had this issue before. Thank you for your help...

We have recently switched to PCPW 5.2 & ReportSmith 4.0. I am having an issue with summing gross earnings in a derived field. On one employee the Sum Distinct works great but on a another is doesn't. The following is the SQL that is not working properly. thanks... SELECT SUM(DISTINCT...

Thanks this works. Except I am still getting 2 rows. Should Term date & Rehire date be in query only,so that I just get the most recent (active) record? Using this case function is new to me can it be used to handle multiple criteria like a nested if statement? Any examples would be great.

A null value, I guess. My issue is that I have active employees with a term date & a rehire date but the rehire date should be greater than the term date. I hope this made sense?

I need a derived field or formula that looks at status =A and Rehire date > Term Date = Rehire else Hire date. I am using PCPW 5.2 Oracle database. Any help is greatly appreciated.

I need to create a field that looks at the union code and if its null they put an "N" else "U". Any suggestions would be appreciated.

Thanks I'll try it...

Thanks....I just the true problem is the employee file # is not in the Title table. I will play around....

I am trying to join the Employees tbl and the Title tbl. I need to include all from Emp tbl and only where the values equal or are null. Any tips are greatly appreciated.

How would I use this just to get a distinct total in the summary footer for a derived field. I keep getting duplicates

Your right. The decode wasn't going to the second W. I will try this thanks and let you know.

Thanks but I forgot a part, we have both Salaried employees paid weekly & biweekly plus straight hourly weekly. I need to include all 3 variables. Like the following but it doesn't work. Any suggestions. Decode("REPORTS"."V_EMPLOYEE"."PAYFRQ"...

Does anyone know how to create the if then function in a derived field? I need to create a field that calculates annualized earnings. I keep trying to create the field using the decode function but it isn't working properly. If PayFreq = B and RateType = S Then Rate1* 26 Else if If PayFreq...

Did you ever get an answer to this? I am trying to do the same thing.

Thanks alot. I'll try it.

Can you email me sample code? I written macros before but pretty simples ones. I appreciate your help.

Has anyone used Crystal Report Bursting? I have multiple letters that need to be distributed to about 100 managers. If not Crystal, Access?