Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. christimess

    Two columns into one

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

    Date format in form report with derived field

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

    Date format in form report with derived field

    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" ||...
  4. christimess

    Issue with exporting as csv, xls (approx. 11000 rows)

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

    Attaching Dependents to Multiple Benefit Plans

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

    Patterned like in Derived Field

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

    What function to use?

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

    Benefit Statements - revisited/suggestions

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

    Pulling the top 2 rows as well as New Hires on a table...

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

    Compare earning code report

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

    Macro Run-Time Error

    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!
  12. christimess

    Macro Run-Time Error

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

    Help with Summary Data Macro

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

    Check view Temp Deptid

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

    Benefits Statements

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

    Benefits Statements

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

    Crosstab - Suppressing lines

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

    Multiply Macro for final result

    ...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 have it work) Or can another derived field or macro be made to say to take the above macro and times it by .04? Thanks!
  19. christimess

    What's wrong with this derived field????

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

    What's wrong with this derived field????

    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!

Part and Inventory Search

Back
Top