Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. LifespanWriter

    ReportBasic Derived Field Macros

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

    Grouping: Listing Details Across, Then Down Page

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

    Grouping: Listing Details Across, Then Down Page

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

    Comic Relief

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

    Count of Codes per Employee ID

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

    Count of Codes per Employee ID

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

    Count of Codes per Employee ID

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

    Saving reports with > 32K records as .CSV

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

Part and Inventory Search

Back
Top