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 Chriss Miller 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: ericfmyers
  • Content: Threads
  • Order by date
  1. ericfmyers

    Data set connecting to Multi Data Set

    I have a multi table report and all was fine in the details until I added in one last table. The main table is set like so: Container {Container.ContainerNumber} {Container.CustomerName} {Container.ProductID} {Container.QTY} The details are grouped by {Container.CustomerName} then by...
  2. ericfmyers

    AS400 combine number fields as date time

    I have number fields on the AS400 that I'm trying to combine into a DateTime value. The first field is the date and was able to create the date value using this formula: stringvar x := totext({EXMP.DATE},0,""); date(1900+val(left(x,3)),val(mid(x,4,2)),val(right(x,2))); The second field is the...
  3. ericfmyers

    AS400 string to date

    I'm pulling dates from an AS400 database but when I try to use the CDate formula it's not returning the correct results. For example, the field contains the value: 1080914 This formula: CDate({TRH00.TXDATE}) returns the date 6/9/4859 which is wrong. The correct date should be 9/14/2008...
  4. ericfmyers

    Matching up two tables with Null values.

    I'm using Crystal Reports 2008 and I'm having a problem with Null values. I have two tables that are being compared in the report to return an account number. If there is no account number setup yet then I would like for it to return a message stating "Please add Account #". The first table...

Part and Inventory Search

Back
Top