Search results for query: *

Hi, All ! I'm using ReportSmith 3.12 and trying to get a report that will give me the Maximum (Last) Check Date when someone's Gross is Greater than a certain amount. I can do a very basic derived field for the Max Check Date, but when I try to tie it together with a dollar amount, I get...

We're going through a conversion from ReportSmith Version 3.12 to Version 5.6.3, both for EPRISE, SQL. We've converted most of our reports with no incident, but I'm coming across a couple that are not capturing everyone they caught in our old system. I started a rewrite and with just the Job...

by searching, I found this one: thread131-1439275 which got just the last part of an e-mail address. I adjusted part of the formula and got to just the first part (the individual's name) by using: SUBSTRING(PS_PERSONAL_DATA.EMAIL_ADDRESS,1,CHARINDEX('@',PS_PERSONAL_DATA.EMAIL_ADDRESS)) the...

Hi, all ! I'm on ADP Enterprise, Reportsmith 4.0 – SQL and trying to capture each person's SUI Tax Code AS OF 12/31/08. I have the report Effective Date AS OF 12/31/08, but everytime I add the SUI Tax Code field, I get every row a person's been in for the year. I tried modifying a Derived...

Hello all; I'm using ADP Enterprise, Reportsmith 4.0 – SQL and trying to upgrade a report that pulls an employee's previous row of Full or Part Time status. I'm using this derived field for the "OLD" and it works just fine: (SELECT OLD_[[FT_PT]].[[FT_PT]] FROM PS_JOB OLD_[[FT_PT]] WHERE...

Since there's a way to do SpellNumber in ReportSmith is it safe to say there's a way to spell out dates? (1/24/01 to show as January 24, 2001)? I also need to spell out other derived field results like a derived field that gives a result of 10 if hire date is prior to 2001; would need 10...

Hi, all; I created a basic Macro Derived Field that works fine and gives the correct result in its own column – Good. But: that Macro Derived Field doesn't show up as a regular Selection or as a Database Grouping Selection, nor is it an option to Sort by. While it's nice to see the column...

We're using ADP Enterprise, Reportsmith 4.0 - SQL. Over the last 2 years since I originally asked about this, has anyone made any great discoveries they can share regarding the need of 2 and/or more AL tables and how to make them play nicely together to get a complete picture in 1 report? My...

We’re on ADP Enterprise, Reportsmith 4.0 - SQL: I’m looking for a better system for when my VP asks for a report of “Who was in this Employment Status, in this JobCode, and in this Location Code anytime within this date range?” An employee may have had several Actions, several JobCodes, and/or...

I have some reports related to Emp Counts that I change the Report Variable each time from 1/31, 2/28, etc, etc to go with the Selection of "Effective Date of Table". Rather than changing the Report Variable anywhere from 3 to 12 times, though, I just wondered if there's a way to do a Derived...

Using Reportsmith for Enterprise, SQL, what would be the best method for reporting the current JobCode and the one most previous to that, without capturing all? The scenario is: someone that has an Action Reason "JTC" with the Action Date being within my specific date range. I want to know the...

I'd posted this in April and still wonder if it's possible so I thought I'd re-post it and see if anyone has any new information and/or whether it's anything that can be done in ReportSmith. As always: ThanX to all ! "We recently went to ADP Enterprise, Reportsmith 4.0 - SQL: I need tips on...

I recently learned (thru Tek-Tips, of course) how to do SpellNumber in Excel and now wonder if it can be done in ReportSmith to save steps. I'm on Enterprise and our RS is SQL. ThanX !

Is anyone aware of a function/formula in Excel that will change: $1236.16 to One Thousand, Two Hundred, Thirty Six Dollars and Sixteen cents ??? It's currently a very tedious, hated-word (manual) process. ThanX !

I've been using this formula (by SQL for Enterprise) to get Years of Service as 1 column, like 2.3: ROUND(CAST(DATEDIFF(MM,((case when PS_EMPLOYMENT.REHIRE_DT IS NOT NULL THEN PS_EMPLOYMENT.REHIRE_DT ELSE PS_EMPLOYMENT.HIRE_DT END)), GETDATE() ) AS DECIMAL(5,2))/ 12,2) Now I have a request to...

We recently switched to ReportSmith Version 3.12, SQL based. In trying to pull individual check details that include Deductions & Earnings Codes, it was identified that those codes are actually in 2 (or more) AL/AutoLink tables. We'd still like all of one employee's data to be in 1 row by...

Is it still possible to get a copy of the Benefit Statement referred to in thread131-765285? ThanX !

We recently went to ADP Enterprise, Reportsmith 4.0 - SQL: I need tips on how to extract date ranges. My example is a Medical Benefit effective 1/13/05 through 5/31/06. Using the effective dating options of this ReportSmith, I haven't been able to grab this person if I just want to know who...

I'm trying to do a derived field for a Benefit Effective date that is "1st of month following 30 days from date of hire" for Enterprise version. In PCPW, I had a formula using: TRUNC("REPORTS"."V_EMPLOYEE"."HIREDATE"+60,'MM') but there is no TRUNC for Enterprise. DATEADD for Enterprise...

I'm new to macros, but thought I was getting close: I've written the macro below to have Summary Fields subtraction done and the test of the macro shows it to be successful, but when I try to insert it and use it in a derived field, my results down the column shows "N/A". Sub FlexMedBal()...