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

Certainly not a surprise - You did it !! [thumbsup2] Have a Star as well as my appreciation ! ThanX again...

Sorry for the confusion. It is SQLServer. ThanX !

Yes'sir - we're non-hosted SQL... ThanX !

Using your test formula, I didn't get any zeros, but did get -1 for the folks that don't have an e-mail address listed. The rest counted the characters in the alias correctly. Does this make it easier or harder? [bigglasses] Really it's not a huge deal if you don't want to spend too much...

Hi, Charles; When I tried your formula I got: "Invalid length parameter passed to the substring function." ThanX !

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

My derived field is working fine - I went ahead and tried your idea to see what happens and it actually removes the answer I'm looking for, so I left the DF as it was. The problem is that I have 2 that have the DF result and another 45 that are null for that DF. I don't want the 45 to pull on...

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

sorry - just meant to bold the characters to enter but it didn't work. Should be: /* enter comment here */

I've used: [b]/*[b] enter comment [b]*/[b]

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

Dear Mr. Cook; YOU ROCK !!! ThanX, ThanX, and ThanX !!!

I surely appreciate your help ! The unfortunate part is that I forgot to include that we're SQL so I can't even view the script of your report...I'm sorry. Is it too long to copy the script here? ThanX Again !!