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: *

  • Users: jkgs
  • Order by date
  1. jkgs

    Reportsmith unable to write to TEMP directory

    That usually does the trick for the IDAPI error. Another idea is checking the TempDataPath value in the INI file to make sure it's a valid folder. Since you mentioned one workstation being fine, it implies something which could differ from workstation to workstation like permissions. Can you...
  2. jkgs

    Reportsmith unable to write to TEMP directory

    Can you delete the .lck files in your profile? John Sakalauskas VantageIS,LLC
  3. jkgs

    Multiple AL (AutoLink) Tables - anything new?

    When looking for batch information you might also include PS_AL_PAYDATA_TRAN and PS_AL_PDE_TAX. Most clients tend to link tables on FILE_NBR and PAYGROUP, however there's also ENTRY_NBR, PAY_NBR, and BATCH_ID available. Basically the first five columns of those tables are options. John...
  4. jkgs

    Reportsmith 3.11 user security

    It would be a combination of a couple different approaches. As Charles mentioned, Reportsmith has a run-time viewer that installed for users who won't be developing reports and just running them. You could also have a set of reports in a folder that the user doesn't have write access to. To...
  5. jkgs

    Employees dropping off when using Telephone_Nbr table

    I worked on something similar recently. Tom touched on a great idea. Run emptblin and develop the query using PS_EMPLOYEES (or PS_ALL_EMPLOYEES). This will help limit issues with effective dated rows. Once you have the data issues resolved, begin by adding the component tables to the query (JOB...
  6. jkgs

    Reading from a text file

    Most clients would probably use an SQR to read in data from a text file particular if they're system is premise (onsite). The circumstances could be more complicated however for a hosted client. I remember a client using a macro to read in a csv file vis Reportsmith. It's somewhat out of the...
  7. jkgs

    Not seeing any data after saving the output.

    For earlier versions of Reportsmith there was a limit of the number of rows you could export. For outputs exceeding the limit we'd get blank files when saving. You could try creating multiple reports and combining them. John Sakalauskas VantageIS,LLC
  8. jkgs

    Report with CHECKVIEWDEDCODE, need actual name of the deduction?

    You could try PS_DEDUCTION_TBL. It has the short and long descriptions of the deduction codes in the system. John Sakalauskas VantageIS,LLC
  9. jkgs

    Job code Change Report help

    Could be an ODBC driver error. If you can try connecting to Oracle without using ODBC. John Sakalauskas VantageIS,LLC
  10. jkgs

    EV4 Hosted - Crash when saving to Excel, CSV and Dif

    Try deleting the temporary SBL files that Reportsmith uses for calculations. The [Macro] or [Macro32] BinaryPath value in WINDOWS\RPTSMITH.INI and RS_RUN.INI may indicate where the sbl files are located. It's often a temp file folder (e.g. h:\temp or c:\temp). With hosting, ini files may be...

Part and Inventory Search

Back
Top