Search results for query: *

Help - have a string field I need to convert to a number field. Can anyone help?

Hello I am using Crystal 9 and a SQL DB. I have to create a report to show all active employees during the period August 13, 2004 and August 20, 2004. I have a table and field for the active status but I'm not reporting on a date field from the database just a time frame that I need to...

I am using Crystal 9 on a SQL database pulling data from our Eden Financial software. Each month employees who are retired pay an insurance premium for health care which, in the database, is called a deduction amount {ESYEMBDD.DED_AMT}. This amount is for their medical plan which is called the...

Hi Everyone I'm using Crystal 9 against a SQL database with Eden Financial Systems and reporting on Benefits and Deductions. We have employees who retain their benefits until the end of the month of their termination (this is their benefit_end_date and should be included in the report I'm...

Good Morning My subject was too long to fit completely so I apologize if it was incomplete. I am using CR9 against a SQL database (Eden Financial Software) My customer needs data for Benefit/Deductions of employees insurance premiums for two payperiods each month and totaled so that she can...

Good Morning I am using Crystal 9 and a SQL DB and doing a report involving employee benefits and deductions. Here is my problem: There is a field in the table I'm using called "line_no" so that there are multiple records. For an example, std (short term disability) for payroll period "X"...

Good Morning I am using data from a SQL database, and using CR version 9. I am doing a Human Resources report regarding pay ranges. The minimum of the pay range is whatever the hourly rate is for step 1 of the pay grade. The maximum of the pay range is whatever the hourly rate is for step 2 of...

Good Morning I am using CR9 and am dealing with a SQL database dealing with employee medical plans. My customer wants the group header to change based on the amounts of the deductions and the amount of the deductions. Hers is my formula and I'm sure there is an easier, shorter way of doing...

Hi Everyone I am using Crystal Reports version 9 and I'm doing a report for my HR department regarding positions in the company. I want to set a parameter so my customer can choose which position number she wants to report on at any given time but when I try to pull the values to use it...

I am working with medical insurance codes in version 9. In our database we have what we called benefit deduction codes and in this case I'm working with a code called "nomed" which means the employee gets paid a certain amount of premium each month if they decline our medical insurance. It is...

Hello I am using CR9 and am working with health plan benefits and deductions. This particular request was for insurance volume (for example, basic life insurance, the volume would be the max amount it would pay if an employee dies). The different plans calculate differently mostly based on...

Good Morning In CR 9 I have an age list of employees but don't want to include terminated employees so if I use this formula: ( isnull({ESYEMPLR.TERM_DATE}) ) it does take out any employee with a termination date but it leaves out employees who have a termination date but were rehired and...

Hello I am doing a report that involves employer benefits and medical plan benefits and deductions. The table I am working with is called {esyembdd.bended_code}. This contains the information on the benefit and deduction codes. Some of them are pretax benefits and deductions and some are...

I have the following formula written but it doesn't return the values as I'm asking it to. These are long term disability and short term disability calculations as my customer would like them: STD Annual salary /52 x .60 x .029=monthly deduction with the maximum monthly deduction not greater...

Hello I'm using Crystal Reports 9.0. I am doing a report concerning health benefits and deductions. I have to include each benefit the employee is receiving and the problem is I have suppressed the name, SSN, Employee ID and salary except on the first record and it is reserving the spaces...