I had to create ReportBasic derived field macros in ReportSmith to add Derived Field result amounts to summary fields. I have them grouped and summed by pay ending date. Here are 2 examples of the ReportBasic macros I used.
This one added the hours from my “REG” derived field to the Summarized...
Thanks for the response! However, I just got a chance to try this and it didn't work... Could I be missing something? I even tried putting in the header and details again next to the first ones, and all that did was repeat the same exact information in a second column. Am I supposed to put...
I have a question that I couldn't fine under keyword search... Someone has requested a report from me to show employee schedule data grouped by shift then by department. In each group, they want to see the details of Employee_ID, Employee_Name, Start_Time, End_Time, Skill. The problem is, they...
Here's a Ballard Street comic that some of my fellow report writers might appreciate:
Richard Sanders
Payroll/HR Systems Specialist
Lifespan Corporate Services
Providence, RI
It works! I had previously tried adding something similar to this:
(SELECT COUNT("X"."EMPLID") FROM PS_ADDL_PAY_DATA X
WHERE "X"."EMPLID" = "F"."EMPLID"
But it appears that my problem was that I was trying to use ERNCD instead of EMPLID, and I also didn't try using the date selection along...
I'm trying to just limit the selection results by only showing where the "count" of ERNCD's for each employee ID is greater than 2, not where the ERNCD itself is greater than 2.
Is there a way I can even just add a selection criteria that will look in the group summaries/footers rather than in...
I'm working on a report to show any employees in a given time period who have at least 2 earning codes (ERNCD) listed in Additional Pay Data in that period. I currently have it showing all employees with addition pays in that period, and have it grouped by employee ID to show the count of...
Does anyone happen to know any work-arounds for running a report in v3.10, and saving the results as a .CSV file when there are over 32,000 records? I'm aware of a limit of 15,000 to save as .XLS, and have encountered a limit of about 32,000 records when saving as a .CSV... but I sometimes have...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.