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!

Recent content by ericfmyers

  1. ericfmyers

    Data set connecting to Multi Data Set

    I tried the running total first but my numbers where still off. Found out that sometimes there are duplicate ProductIDs for the containers that throw the totals off. I'm going back to the Database manager and see if we can add a Y/N switch to the container table that states if it was worked on...
  2. 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...
  3. ericfmyers

    AS400 combine number fields as date time

    I spoke too soon. I have a few fields that haven't been filled yet. Their value is 0. My work around for now is using these two formulas: {@CheckDate} if isnull({EXMP.DATE}) then 1000101 else if {EXMP.DATE} = 0 then 1000101 else {EXMP.DATE} {@CheckTime} if isnull({EXMP.TIME}) then 101 else...
  4. ericfmyers

    AS400 combine number fields as date time

    Mike that worked! Just had to add a couple of parenthesis. The date field is formatted as YYYMMDD. The first number indicates the century. Anything before 2000 was then just YYMMDD. The main tables were created in the early 80s, and this was the programmer's fix for Y2K. I'm not sure why they...
  5. 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...
  6. ericfmyers

    AS400 string to date

    That worked perfectly, thanks!
  7. ericfmyers

    AS400 string to date

    I tried that and then it was asking for a string then I realized that this is a number field. So in the formula I converted the field to a string then I added your code under it but now I'm getting the error: "A month number must be between 1 and 12" So then I tried: numbervar x :=...
  8. 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...
  9. ericfmyers

    Matching up two tables with Null values.

    That worked! Thanks!
  10. 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...
See more

Part and Inventory Search

Back
Top