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!

  • Congratulations SkipVought 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. CharlesCook

    Reportsmith Installation on Windows 7

    Try "compatibility mode" for Windows 95 or 98. RS 3.0 came out in 1995(ish). If that does not work, I would call ADP and/or SRS tech support. http://CharlesCook.com Specializing in ReportSmith Training and Consulting
  2. CharlesCook

    Problems with YTD Accumulator report - employees are missing!

    From the ADP Data Dictionary: ADP Enterprise HR Data Dictionary EMPLOYEES This table is created by running an SQR program that selects particular columns from the following tables that are current at the time the program runs: PS_PERSONAL_DATA, PS_EMPLOYMENT, PS_JOB, PS_JOBCODE_TBL...
  3. CharlesCook

    Total Hours from V_CHK_VW_HOURS

    This may help: http://charlescook.com/PPS/ADP/ReportSmith/PCPW/DatabaseGrouping.pps http://CharlesCook.com Specializing in ReportSmith Training and Consulting
  4. CharlesCook

    Tenure - Dervied Field

    I think we will need to start from the beginning. Define Tenure. Is it Current Date - What unit of measure (days or months or years). http://CharlesCook.com Specializing in ReportSmith Training and Consulting
  5. CharlesCook

    Tenure - Dervied Field

    Hi, SQL is not the brand. SQL is like minivan or pickup or SUV (type). Oracle is like Ford or Chevy or Dodge (Brand). I need to know the brand as the SQL syntax is brand specific. For example Oracle syntax it different from SQL Server and Gupta etc. http://CharlesCook.com Specializing in...
  6. CharlesCook

    Display Manaagers EMPLID for each employee

    This sounds like a Data Exception to me. A Data Exception is invalid data in a field for example the letter A in a numeric field. I would try to narrow down the selection to make sure the report is ok otherwise. Then start looking for the bad data. http://CharlesCook.com Specializing in...
  7. CharlesCook

    Tenure - Dervied Field

    What Brand (Oracle, SQLServer...) database are you using ? For example there is no DATEDIFF function in Oracle. Also could you post your formula. http://CharlesCook.com Specializing in ReportSmith Training and Consulting
  8. CharlesCook

    Reportsmith Question

    Your welcome !!! http://CharlesCook.com Specializing in ReportSmith Training and Consulting
  9. CharlesCook

    Reportsmith Question

    You don't change the "data field" part. You change the "of values" part. "Data Field Emplid Is NOT in list Of Values Values" CHANGE TO "Data Field Emplid Is NOT in List Formula _______" AND "Data Field Emplid Is NOT in List Formula PUT YOUR COPIED SQL IN HERE" http://CharlesCook.com...
  10. CharlesCook

    Devired Field with Projected Dates

    Sorry, Yes I would use a Macro Derived Field in ReportSmith. The macro lang is an old version of basic. It gives you the ability to do If Then Else logic and loops etc. The mail difference between an SQL derived field and a Macro derived field is in SQL you must do all of the work with 1...
  11. CharlesCook

    Reportsmith Question

    This is an example of a style of report I call the “everyone that’s not here raise your hand” report. Here is how I would look at it: 1.) Create a report that has the very basic info in it for all active employees. 2.) What if you could get rid of the people that have had a check by typing in...
  12. CharlesCook

    Devired Field with Projected Dates

    You will want to do this in a macro. http://CharlesCook.com Specializing in ReportSmith Training and Consulting
  13. CharlesCook

    Summary of Hours Worked in a Year

    The trick is using Database Grouping. How you group the data will determine how many lines you get back (or how the data is compressed). Start by looking at this: http://charlescook.com/PPS/ADP/ReportSmith/PCPW/DatabaseGrouping.pps Charles Cook Charles@CharlesCook.com http://CharlesCook.com...
  14. CharlesCook

    Reportsmith fields displaying 0 values

    I would make a copy of the report. Then I would try doing a table replace for each table against sql server 2008 in 2000 compatibility mode. http://CharlesCook.com Specializing in ReportSmith Training and Consulting
  15. CharlesCook

    Outer Join Problem running report with SQL Server 2005

    I can only get you started as I don't have the documentation. You will need to modify the [SQL Server] section of the RS_SQLIF.INI file. Contact ADP and/or SRS for documentation on this file. http://CharlesCook.com Specializing in ReportSmith Training and Consulting
  16. CharlesCook

    Getting only first part of E-Mail

    Try this: CASE TRIM(PS_PERSONAL_DATA.EMAIL_ADDRESS) /* Get rid of empty email addresses */ WHEN IS NULL THEN ' ' ELSE CASE CHARINDEX('@',TRIM(PS_PERSONAL_DATA.EMAIL_ADDRESS)) /* get rid of email address without an @ */ WHEN 0 THEN ' '...
  17. CharlesCook

    Getting only first part of E-Mail

    I need to know the BRAND of SQL you are using. Oracle and SQLServer are examples. http://CharlesCook.com Specializing in ReportSmith Training and Consulting
  18. CharlesCook

    Getting only first part of E-Mail

    What brand Database are you using? It's not Oracle is it SQLServer? http://CharlesCook.com Specializing in ReportSmith Training and Consulting
  19. CharlesCook

    Getting only first part of E-Mail

    Create a new derived field with just this in it. (CHARINDEX('@',PS_PERSONAL_DATA.EMAIL_ADDRESS)-1) Does that work? Does it ever return 0 or a negitive number? http://CharlesCook.com Specializing in ReportSmith Training and Consulting
  20. CharlesCook

    Getting only first part of E-Mail

    Try this: SUBSTRING(PS_PERSONAL_DATA.EMAIL_ADDRESS,1,(CHARINDEX('@',PS_PERSONAL_DATA.EMAIL_ADDRESS)-1)) http://CharlesCook.com Specializing in ReportSmith Training and Consulting

Part and Inventory Search

Back
Top