Search results for query: *

My apologies, I did not accurately state the issue. Below is the sample data: Name Position Action Effective John Doe 2558 Correction 10/6/2010 John Doe 2558 Supv. Change 10/6/2010 John Doe 2558 Update 10/1/2010...

I am attempting to retrieve the previous positions/job data within a table. However, I am having problems because the table has instances where the position/job is duplicated. Below is the sample data: Name Position Action Effective John Doe 2559 Correction...

Please allow me to clarify. Below is the data prior to application of any formulas: Emp. Posn Job Beg Date Action Pay 1 10 01 1/1/09 Promotion 10 1 11 02 10/31/08 Salary Incr. 9 1 11 02 5/30/08 Promotion 8 1 12 03...

I apologize....it should have read "....old job formula...

I am not sure if I understand what you are asking.... I do not have a formula for the new job code as this is populated when the promotion data is entered into the system. In other words {PAEMPPOS.JOB_CODE} is the new job code. I think I may have confused you with the column headings, for that...

Thanks, the suppression works!!! However, when I pull records for several employees simutaneously (within a date range), my "new job" formula does not return anything. Everything works perfectly when I am pull records for one employee at a time. Please advise. I am still using the following...

I apologize for the confusion. Below is the data prior to the application of the formulas: Emp. Posn Job Begin Date Action 1 10 01 1/1/09 Promotion 1 11 02 10/31/08 Salary Incr. 1 11 02 5/30/08 Promotion 1 12 03 1/14/08...

I see. Is there a way I can suppress the blank fields and display other data in the detail section? For example Emp Job Old_Job Action 1 Mechanic Apprentice Promotion 1 Apprentice SAL CHG 1 Apprentice Trainee Promotion As info, I have...

When I suppressed the blank section nothing happens. Do I need a formula...conditional formating perhaps?

Your solution works perfectly!!! Thank you. My desired result has changed a bit. Below is the data sample: Emp. Posn Job Beg Date End Date Action Pay 1 10 01 1/1/09 Null Promotion 10 1 11 02 10/31/08 12/31/08 Salary Incr. 9 1...

I am new to Crystal. I am attempting to create a promotions report and am having trouble displaying the previous job & position codes. This report will have a date condition and an personnel action condition. Below is an example of the data. Emp. Posn Job Begin Date End Date Action...