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

    How to calculate Period Begin Date in a Derived Field or other

    Hi Charles, Thank you for the quick response. I'm still learning about properly using selection criteria, derived fields and grouping. In fact, I'm giving some time to replicate checkview data, but it may be a moot issue since I'm planning on upgrading ADP, which means Crytal Reporting...
  2. Helixe

    How to calculate Period Begin Date in a Derived Field or other

    Hi Charles, I believe your suggestion applies to a different version of ReportSmith as our tables start with "V_". But actually, I don't think it matters since your suggestion is spot on and I actually continued working on the calc after I posted this question. Here's what I came up with and...
  3. Helixe

    How to calculate Period Begin Date in a Derived Field or other

    Hello, I am using ADP PCPW V 5.1, and ReportSmith V 4.2.2002/Oracle. Acording to ADP, "period begin" date is calculated and not stored, therefore, this date is not available in tables. I'm thinking that a derived field can calculate period begin from either paydate-12 or period end - 13...
  4. Helixe

    Creating a check detail Report

    Hi Charles, Thank you for the quick reply. I figured as much that trying to create a detailed Check report was something only someone like yourself could write. It's almost like trying to recreate ADP's CheckView, but one that you can call based on selection criteria. I've actually had success...
  5. Helixe

    Creating a check detail Report

    Hello, Our company is using PCPW 5.1 and ReportSmith 4.2. I started to create a CheckDetail report by Paydate, and have created derived fields for each earnings code, deduction code, statutory deds, gross, net and memo codes. I started with a label template and sized the margins to fit two...
  6. Helixe

    Combine employee data to 1 row per employee...

    I avoid saving to an Excel file directly in ReportSmith. This may be the problem with your file bombing out. It might be a matter of file size. I normally save to a Text file with "retain format". I then use Excel to open the Text file. The app will prompt you to choose between delimited or...
  7. Helixe

    Derived Field or Macro

    Charles, Thank you for the quick reply. Yes, I too am more familiar with ReportSmith under the ADP Enterprise application. I will attempt to utilize your suggestion and post my results if successful. Thank you,
  8. Helixe

    Derived Field or Macro

    Hello, First off, our company utilizes PCPW 5.1, and Reportsmith ver 4.2 (oracle) Being a new user, I've searched the forum to verify if my question has already been posted. There are a couple that are similar but not exactly what I'm looking for. I'm hoping someone can assist. I've created...

Part and Inventory Search

Back
Top