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 dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by AtlPayroll

  1. AtlPayroll

    Number of Employees Receiving Paychecks over Period

    I've got a report that lists all of the paycheck generated within a period of time. This report also has a summary footer that sums up the Gross & counts the total of Number of Check. I'm trying to get a summary of the number of unique employees getting checks. If there are multiple pay...
  2. AtlPayroll

    Numbering Rows

    Is there a way to have a Derived Field sequentially number rows starting at a fixed number, such as 101, and increase by 1 for each row of data displayed?
  3. AtlPayroll

    Report Variables rerun

    I wrote a report that has a report variable asking the user to select from a long list what type of selection criteria data they want to see such as: 01 - Show me any employee that is missing a Birthdate 02 - Show me any employee that is claiming Fed Tax EXEMPT 03 - Show me any employee that has...
  4. AtlPayroll

    Comments in Derived Fields

    Does anyone know if there's a special character set or key work that allows the programmer to enter comments into a Derived Field for Oracle RS?
  5. AtlPayroll

    IN statement within a CASE statement

    I'm creating a Derived field. I've got a CASE statement that currently works: CASE "JOB"."JOBCODE" WHEN 'COP367' THEN 'YES' ELSE 'NO' END What I'm needing is to incude a an IN statement CASE "JOB"."JOBCODE" WHEN IN('COP367','COP368','COP369') THEN 'YES' ELSE 'NO' END But I get an ORA-00936...
  6. AtlPayroll

    Summary Fields within Selection

    Is there a way a summary field can be used within the selection criteria? If not, is there a way to write a derived field (SQL formula) to sum up a column of a Report Grouping? Example - column Hours for one employee has REG 45, OT 5, VAC 40, Sum of Hours 90. How could I use this Sum of Hours...
  7. AtlPayroll

    ALPAY010

    I understand what you're saying but here are my thoughts. From the JOB table, you select all active hourly employees. As soon as you link the AL_CHK_DATA table, it's going to drop off employees who don't have any data in this table. Is there any way other than a Master/Detail report to have a...
  8. AtlPayroll

    ALPAY010

    We're currently using ADP Enterprise 3.0 Autolink. One of the regular payroll audit reports is the ALPAY010 - Active Hourly Employees with No Hours. I'm trying to write this in ReportSmith because I have multiple paygroups (and the Enterprise report only generates one paygroup at a time) as...
See more

Part and Inventory Search

Back
Top