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!

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

Recent content by pjl923

  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

    How to check a section and/or a subreport if is empty ?

    Madawc, I used your suggestion on a sub report to print ' ~ No Shipments ~' when no records existed in the subreport. I chose the 'Shipment #' field in my database to test and it works great! Thanks.
  3. pjl923

    AS400/MAPICS Date Conversion

    Thanks so much...works great. How can you use this as a parameter/select field though?
  4. 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...
See more

Part and Inventory Search

Back
Top