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.

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

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.

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.

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

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