Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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