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

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

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

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

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

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

I saw on here an old post regarding the nested subtotaling issue with microsoft excel 2003. Here is part of the old post: I got in contact with Microsoft and there is a fix for this that requires an update to the registry to tell Excel 2003 to use the Excel 97 subtotal method since the new...

Below is the code that allows the user to select the file that needs to be imported and displays the file and it's path in a listbox. It works great except it doesn't take the next step of importing the file into the database as a table. How do you tell access to import the spreadsheet that is...

The filedialog command box is working in my form so it opens the dialog box for the user to select which files they want to import and it shows it in a list box. I'm not sure what to do now to have it actually import the files into my database...this seems like it should be a no brainer, is it...

I am trying to use the macro feature in Access to have it import a file with the click of a button and it works fine as long as the file stays in the same place every single time but it doesn't. Every 2 weeks the files are new and I need to be able to give the access user a lookup dialog box...