Search results for query: *

Hi, I am new to writing arrays in crystal reports. I need to be able to show total hours and total wages for each pay code, grouped by center. I know I can create several derived fields with an if then statement to only show the hours and earnings for each pay code BUT pay codes can be...

This is the first time I've created a cascading list and it's broken down with employee status, then location, followed by department. It works except for the fact that sometimes the end user may want to run it for all status's, all locations and all departments or some combination of those...

Okay, I need to be able to show an employee with their benefit plan code Ex: PPO and beside it show what that employees deduction code is Ex: MD08. As you can see, these codes are not the same but they represent the same medical coverage; one code is for the HR benefits group and the other is...

That worked! Now the group footer b is displaying at the top of the next page! How do I get it to display correctly? I am playing around with the section expert and nothing's working. Ugh. Thank you for your help, I'm sure I can figure out how to make it look "pretty". Thank you lbass!

The crystal report is a letter to all ee's showing their total compensation package. The first page of the letter is the main report and the two subrpts are for the retirement plans and benefit plans. I created subformula's in both subrpts and main formula's in the main report. The main...

I am using the employees job history table and trying to compare the current process level (aka pl) to the previous pl and have only the employees most current row displayed if there is a different in pl's. I am using the Next function as a formula field to identify the previous pl and that...

This access database produces the LOA letters that we send to employees telling them what their benefits are and what they are required to pay while they are out on leave. The report also displays anyone that has a benefit with a future dated coverage begin date. Several of our employees have...

I had this issue too and I saved the file into excel and used the round function in excel to get the correct amount. If you use =round(a3,-3) it will round correctly for you. A3 being the field with the $23,670.00. I know it would be nice to get this to work in Reportsmith but if you don't...

Our vendor wants us to add a column that will identify employees that have had: A- no change, we'd look at coverage action dt is less than prior file date (the previous Monday) to determine that no action has taken place during the past week N-new business, if coverage election date is>current...

Never mind. I found the correct table to use, PV_GENL_DEDUCTION with emplid as the primary key and tied it to PV_AL_CHK_DED with emplid and dedcd. I knew I'd figure it out, I just haven't looked at any 401K stuff in awhile. :-) Sarah

I am using the PS_GEN_DED_TBL to show each employees 401K%; is the primary key for this table DEDCD and how do I tie to employee records? TIA, Sarah

Okay, below is the sql statement that I have in the selections portion of reportsmith. I am trying to display an employees current benefit program and their previous benefit program (if they have one). What's happening is I'm getting multiple rows for some people, not everyone. I know it's...

Okay, I've tried sum(distinct decode and I think it's not working because I'm trying to use sum on a non-numeric field. I'm trying to show all the benefits in pv_health_benefit table with 1 row per employee with columns like such: Emplid Name Medical Dental Vision 1234 Susie Que...

Okay, I saw one reply to an earlier post regarding rounding to the 1,000th but I haven't been able to get it to work: 1. Add 999 to your original field. 2. Truncate to a derived 2 digit integer field. 3. Multiply by 1000 with result in an appropriate size derived field to accomodate your...

I have a report that shows employees that have worked at least 6 months from the date the report is run. I am creating a derived field to display their Coverage Begin Date as being the 1st day of the following month. So, if my company seniority day is 04/03/2005 than my Coverage Begin Date...

Yes, I am looking at CHECK_DT being less than or equal to the check date the enduser selects in the report variable. So, if the enduser runs this report for today, 03/31/2006, it will display anyone with an action of LOA with an action date of 03/31/2006 or less. I did include that CHECK-DT...

Okay, I know I have been able to do this before and I can not remember what I did besides check marking the box "Include Unmatched Records" when trying to do an outer join between the PV_JOB table and PV_AL_CHK_DED table. I am trying to show everyone that is on LOA that has benefits and show...

Okay, I have derived fields for the different rows and have queried only so the different levels are no longer there. How do I have the report group on these levels and only show 1 row per employee? I read in earlier postings that you create one total derived field with all your fields in it...

No, there's nothing I can think of with regard to the benefit plan row. The effdt field has an effseq field but it's zero for almost every row unless two transactions occur on the same day giving the same effdt so your effseq for one of the rows would be 1. That's why I don't know how else to...

Okay, when an employee's status changes from FT to PT their Benefit Program changes. Their most current benefit plan row is not what I need; I need the row right before their status change, what is the best way to get this? Any suggestions are appreciated, Thank you, Sarah