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 TouchToneTommy 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: pjl923
  • Content: Threads
  • Order by date
  1. pjl923

    Conditional suppress based on total records in two groups

    Using CR11 Have a pretty simple report that I'm trying to use as a cycle count worksheet. I want the user to perform 26 counts a day; so I want to show them only 26 records. I select records from the db based on a 'next count date' field I calculate from a dynamic 'last count date' field in...
  2. pjl923

    AS400/MAPICS Date Conversion

    I'm using CR 8.5 to pull data off AS/400 running MAPICS XA r6. DATE fields come over as a numeric (e.g. 1,050,307.00; which is 03/07/05). I've pulled down from the BO website a function 'NumberToDate' which converts the field to a number. The problem is the century code of '1' at the...

Part and Inventory Search

Back
Top