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

Part and Inventory Search

Back
Top