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. maryb701

    Combine employee data to 1 row per employee...

    Artie ! thanks for the help on the phone. YOU ROCK!!!!!
  2. maryb701

    Combine employee data to 1 row per employee...

    thanks Artie, i will call when i get in tomorrow.
  3. maryb701

    Combine employee data to 1 row per employee...

    one more thing...it does not seem to be pulling everyone up
  4. maryb701

    Combine employee data to 1 row per employee...

    Ok i did that...but I am still getting one line per check date rather than one line. these are my derived fields: Ck Gross: SUM(DISTINCT "PS_AL_CHK_DATA"."CK_GROSS") StateTax: SUM(DISTINCT DECODE("PS_AL_CHK_DATA"."STATE_TAX_CD",'31',"PS_AL_CHK_DATA"."STATE_TAX_AMT",0 ) ) LocalTax...
  5. maryb701

    Combine employee data to 1 row per employee...

    Thanks. I will check that out
  6. maryb701

    Combine employee data to 1 row per employee...

    yes and I can't get it to work with EV4 reportsmith. Unless I am not understanding something.
  7. maryb701

    Combine employee data to 1 row per employee...

    if i run a report showing various paydates for an employee for a quarter, how can i combine them to one line per employee. The accumulator cant be used because it is for a previous quarter. example: J.Smith 1/1/07 $300 J.Smith 1/17/07 $500 J.Smith 2/4/07 $600 can i get this...

Part and Inventory Search

Back
Top