Search results for query: *

Hi, I'm using oracle (hosted) and need to turn Date_C and Date_D from the EMPLOYMENT_TBL into one column. It is possible that an employee has a date in each field, which I would then need that employee to have two lines. I also need to be able to have a field that can then tell me if that...

Thank you, Thank you, Thank you Artie. I was trying TO_DATE and it worked with TO_CHAR.

Hi, I hope you had a great weekend! I am creating letters using forms. I'm creating the body of the letter in a derived field as I am using text and fields from other tables. So for example the body derived field may state: 'Based on your rehire date of ' || "PS_EMPLOYMENT"."REHIRE_DT" ||...

Are you hosted and if so what drive are you trying to save to? If you are hosted and trying to save it to your personal computer, I would save it to the 'H' drive and them move it to your personal computer.

Have you tried to add the table multiple times, one for the individual and once for the dependents? Or rather than doing a complex outter join, create what you need in a derived field? I haven't done this for Benefit Plans, but had to do it for other tables and it works pretty well.

I am trying to create a derived field that looks like this: DECODE(SUBSTR("PS_EMPLOYMENT"."CUSTOM_AREA1",1,4), LIKE '1%%%', 'FEDERAL', LIKE '2%%%', 'STATE', 'UNKNOWN') However, it does not like my statement. I know I can do it the long way: DECODE(SUBSTR("PS_EMPLOYMENT"."CUSTOM_AREA1",1,4)...

I need to create a derived field that if PERSONAL_DATA.SSN <> AUDIT_PERSONAL.SSN that it will list the AUDIT_PERSONAL.SSN. If it is not applicable (meaning that the 2 SSN's match) then I need it to be a space (' ') so that is is blank. What I don't know is what function to use with this...

If you have two checks and only want the max I would have something in the statement about payroll #1, vs payroll #2 (payroll 2 being the latest). I have used the footer like a form and for the most part it works well. It has worked out very well for me in almost every situation. The only...

Hi, What you will want is for your 1st JOB table to be max effective date so that it gets the latest. That line should read: data field JOB.EFFDT is equal to formula (SELECT MAX(JOB.EFFDT) FROM PS_JOB WHERE JOB.EMPLID=JOB.EMPLID) For the next JOB table you will want to enter a new selection...

I am trying to create a report where you select a check date and earning code and it will compare that information to the last check date and if that earning code is not there it will list that employee on the report. We thought of doing this with a derived field. We created the following...

Hi, Thanks for the help. I think what I need is an NVL function, however where I am stuck is that if the value is 0 then what should I be changing it to to make the above macro work? Thanks!

I created the following macro: Sub Percent () X=VAL((Field$("OVERTIME_HOURS")) / VAL(FIELD$("AL_HOURS")) DerivedField Str$(X) End Sub "OVERTIME_HOURS" is a derived field "AL_HOURS" is a column from the AL_CHK_HRS_ERN table. When I test the macro it states it is compiled successfully. When I go...

Hi, I am trying to do something similar in that I am trying to create a macro to calculate overtime percent. So I want it to take the Overtime Hours column, which is a derived field that adds multiple earning codes and divide it by the AL Hours from the PS_AL_CHK_HRS_ERN screen. From the...

Hi, I am trying to create a report that uses AL_CHK_DATA (for the TEMP_DEPTID and AL_CHK_HRS_ERN (to pull the earnings that go with the TEMP_DEPTID). I can have up to 9 TEMP_DEPTID's and neeed to find a way to include all of them in one report, one line for each TEMP_DEPTID. In looking at the...

abardel: Don't go to Insert ~ Detail. If you go to Format ~ Section and click on your 'dependent' report (lower right corner of the box) I believe the "hide section" is checked. You need to uncheck this box.

Abardel: You are trying to drop the information from your detail report into the wrong section. For example if you are trying to drop information from the detail1 report you must drop it into the detail1 section, not the master. It is my opinion that although it clutters the screen this is a...

Have you tried going to Tools, Report Grouping, double click on the group and then suppress?

I have created the following macro: Sub udr5() If (Field$("CombineYear")) = "Under 15" Then X = (Field$("AccumNYTDinOne")) End if DerivedField str$(X) End Sub Is there a way that within the above macro I can add a line to say something like X = (Field$("AccumNYTDinOne"))*.04 (but of course...

I tried that but it did not work. I can't figure out what is wrong with it. I have delt with many derived fields like this, but I have never had this many problems with it before.

Hi, I am trying to create the following derived field: SUM(DISTINCT CASE "PS_AL_CHK_HRS_ERN"."ROW_NBR" WHEN '1' THEN "PS_AL_CHK_HRS_ERN"."AL_HOURS" ELSE 0 END) but it keeps giving me the error message "ORA-00932: inconsistent datatypes: expected NUMBER got CHAR" It is an Oracle database. Thanks!