Recent content by mercadi

PERFECT, PERFECT, PERFECT!!!! Thank so much. I had to sort my AMT column, but it worked.

This is pretty much it for the spreadsheet. I do have some other columns in the spreadsheet but nothing that would really help this. I just have over 3000 entries and they are wanting to know the priority level for each deposit on each employee. So if the employee has 2 or 3 differant...

Hello, I'm needing some help figuring out how to write this IF statement or if there is some other formula that will work better. I have an EXCEL2000 worksheet that I need to prioritize the data. Let me explain. SS# Order Priority AMT Default Desc 111-22-3333 99 9999...

We use SQL. I use CR9 for almost all my reports. I do run into some problems with HISTORY but for the most part I have no problems pulling from KRONOS.

I thought the data was overwritten but there is a button on the employee screen that is ALL RECORDS and when you click on it it pulls up an individual little box that shows all the dates this employee has hired on, termed on, rehired on, etc. I'm just not sure where the data is stored and how...

Sorry this is going to be lengthy again, because its hard to explain and I know you guys like to have all the information since you can't actually see the report: I have an EVENT screen in our HRMS (KRONOS)system where we log the information in field boxes. Event Field (what type of...

Ok, I'm going to give this my best shot in explaining the help I DESPERATELY need. First, let me say, I'm not an expert at Crystal so please bare with me and I hope someone will help me....this will be somewhat lengthy. I use Crystal 9 Here is what I need my report to end up looking like...

This report works great, it just doesn't pull in the new data that was placed in HRMS with effective date 4/01/06. Still trying to find a way to pull those employees as well.

I believe the table updates after the coverage is actually effective but the insurance carrier is wanting to see all the new changes now and I'm not sure how to pull those folks out. Sorry Synapsevampire. I'm not sure what your asking when you say "show what's in them". Here is my SQL Query...

Not sure I'm giving you the right info. Hope this is more helpful. I created the report in Crystal TEXDB4 database and the data is pulling from our HRMS system. The effective date for the Dental changes to take place is set in HRMS for 04/01/06. In my Benefit Enrollment table that I used to...

I created a report showing employees that have Dental.(Benefit_Enrollment_Curr.BenefitPlanCode) We just had open enrollment and the employees that signed up for Dental or made changes will go into effect on 04/01/2006. When I run the report the new changes do not show because they are in the...

CR 9.0 I hope this is easy. I currently have a report that I pull in current employees.(EmployeePos_Stat_Curr.Fullname) It shows basic stuff, how many employees per department. What I need is to pull past current data. For example, I need to see how many current employees we had back in...