Search results for query: *

I'm going to email you a BMP file of it.

Thanks, Charles. That did it. I changed the criteria from "effective date of AL_ALA_DATA is report's effective date" to a list, where ANY can be true, either 1. "effective date....." or 2. effdt is null. Thanks, again.

I'm joining JOB to AL_ALA_DATA. I want everyone's job data, even if they do not have an entry in AL_ALA_DATA. However, when I add AL_ALA_DATA and link it to JOB, I lose the unmatched records, even though I have checked "show unmatched records" for both file number and paygroup links from JOB to...

I'm at a client who uses a custom SQR - which ADP charges them for each time it is run - to produce its Fidelity interface. The output is in fixed field length and multiple "records": one for name, one for address, one for city/state/zip, one for 401K data, which means they have multiple rows...

Thanks for the guides. Unfortunately, until I have some formal training using macros, or at least an example, it's all Greek. What I want to do is show Overtime Hours as a percent of Regular Hours and Overtime Earnings as a percent of Regular Earnings. (OT/REG) Reg hours and earnings come from...

This is Enterprise V4, RS 3.10. I have two columns, one with REG hours, the other with OT hours. I can create a derived field which compares OT hours to REG hours at the detail level as a percent (OT/REG). I can sum the REG and OT hours columns by dept or paygroup. Is it possible to compare...

I want to compare overtime hours to regular hours; overtime earnings to regular earnings. I have columns for OT hours and REG hours, earnings as well. Can I compare two columns in Crosstab? Or must I use a derived field? Problem with a derived field is that I get no rows, because OT...

I am sending you a Word doc with even more screen prints than you ask for.

OK. My selection criteria look very much like yours. I did have to change "PS_JOB" to 'JOB1", since I'm using an alias for PS_JOB. This selection brings up everyone with a current and history row - only one row. That's good. However, the NULL is not working, as is isn't working for me. I get NO...

Yes, ADP. I retired from the Army 7 years ago, becames asst controller at a large university and hated it. Got into consulting with AG Consulting, which was owned by ADP. Obsorbed into straight ADP after AG was sold. I am an implementer in Professional Services and took it upon myself to learn...

Charles, Now I remember why I didn't finish checking this. From your ealier reply: "COPY THE SQL FROM THE NEW WINDOW AND POST IT HERE. I WILL POST BACK THE CHANGES. Make the changes I post and run the report. Then let me know how it goes." I was waiting for more data from you.

Charles, Yes, I looked at it. Sorry I haven't responded. Very busy. I reviewed it and it looked exactly like what I was trying to do. However, because of your message, I reviewed it again.The only difference I see is that I'm using effdt instead of emplid as the test for null. I will change my...

I guess you haven't had a chance to look at the sql?

Like this? SELECT DISTINCT (select distinct decode(b.action,'HIR','No Reason Given',b.descr) from ps_actn_reason_tbl b where (b.action_reason = job1.action_reason and b.action = job1.action and job1.action_reason <> ' ') or (b.action_reason = 'TMP' and b.action...

No attachment, I guess. Here are the details of my selection criteria. Tables are JOB and JOB1, where JOB.EMPLID is linked to JOB1.EMPLID 1. data field JOB.EFFDT is equal to formula (SELECT MAX(JOB.EFFDT) FROM PS_JOB WHERE JOB.EMPLID = JOB.EMPLID) 7. ANY of the following apply: 7.1 data...

Earlier, I had a thread where I got "no rows found" when trying to display current JOB row and previous JOB row, when no history existed. I found a fix for that: include a condition where the history effdt is either null or equal to the current row. However, that adds a new problem: Where...

Answer from the Hosting Center: The Graph function is not installed, at it requires MS Office, which would mean lots of licenses........

Well, I've turned it into the tech desk for research. They probably never installed it at the hosting center.

I tried the Graph function. No luck. I get a message "Microsoft Word Graph not installed. Please reinstall Microsoft Word" or something similar. This is RS 3.11 in ADP Enterprise version 4B, hosted. Anyone ever successfully use the graph function in this environment?