Ok, I assume your talking about my tables so I've typed them in below. The Join Type is INNER and LinkType is equal. I'm linked by PersonIdNo. When I add the second table (Persons_Addresses) is when I get duplicates.
FIRST TABLE
xxx_PERSONS_PRIMARYADDRESSES_CURR
PersonIdNo
FirstName...
I have a report that has the employee name, address, city, state but now I need to add the county and that is in another table. When I go to link the table on PersonID it gives me duplicates. Anyway to make that stop?
OK, let me see if I can explain this so you know what is going on. This is a subreport that was created in my report.
Let's say I have this pay period of 06/27/05 - 07/10/05
and the employees Annual eval is due 07/04/2005. (which falls in between these two dates)
If the eval falls in between...
strange but this actually worked in a differant report. Not sure why it doesn't work in the one report but I'll figure it out. Thanks for all yall's help.
Sorry I copied over the other one I was using. This is what I have in there now and it still rounds the months up to one year. Here is what it looks like.
NAME POSITION HIRE DATE YEARS OF SERVICE
Ima Test Job-Position 9/28/2004 Year 1
Years of service should be Months...
if isnull({EmployeePos_Stat_Curr.LastHireDate}) then 0
else If cstr({EmployeePos_Stat_Curr.LastHireDate},"MMdd") <= cstr(CurrentDate,"MMdd") then
Year(CurrentDate) - Year({EmployeePos_Stat_Curr.LastHireDate})
else
Year(CurrentDate) - Year({EmployeePos_Stat_Curr.LastHireDate}) - 1
I actually...
Synapsevampire, the formula is still not pulling in just months. It now is rounding the 0 up to 1. So if the employee has been here 8 months, it shows year 1.
In this formula, this will pull in the current employees who's hire date was in the current month. How can I do the formula where if I need to pull September employees now, I can?
Month({EmployeePos_Stat_Curr.LastHireDate}) = month(currentdate)
Sorry, not sure what you mean by insert a group. I did go in and grouped employees together and now if an employee has more than one coming up you can see it. Here is an example.
EMPLOYEE NAME NEXT REVIEW DATE
employee test 06/04/2003
employee test 06/04/2004
employee test...
I have a report that pulls in employees and their Next Review date. Instead of pulling the lastest and greatest next review date, say one due in 2005, its pulling all next review dates that every employee has ever had. Is there a way I can tell it to only pull the most current next review...
I'm sorry, guys I don't know why I can't get this to work. I'm copying your formula over into my report and there are no errors but when I run it, it doesn't give me 8 months it stills give me 0 months.
Thanks for all the help. I've learned Crystal on my own and I'm not up on all the...
This one might be easier.....based on your formula to pull in current month
Month({EmployeePos_Stat_Curr.LastHireDate}) = month(currentdate))
Instead of pulling in "current" month, how can I pull in whatever month I need? I tried changing the last part of the formula but its not working.
Thanks.....maybe you can tell me this. I have years of service using this formula that works great.
Datediff ("yyyy", {EmployeePos_Stat_Curr.LastHireDate}, CurrentDate)
The thing is, if the person has been here less then 1 year it will show 0. Is there a way, I can have it show their actual...
I have a report that shows me the employees HIREDATE. What I would like is to be able to only pull employees who's anniversary date is for the current month.....
{EmployeePos_Stat_Curr.LastHireDate}
This is something I need to know too. I've been trying to do a trend chart showing the top 10 departments that show overtime each week so we can see if the same department keeps showing up with overtime. I have my report actually in EXCEL but not sure how to create a chart off it.
What I'm trying to do is find the years of service but I want it to tell me the exact amount of service. So if they have only been here for say 8 months I don't want it to print a 1. I want to see the exact months so I can remove those from my list.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.