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

Part and Inventory Search

Back
Top