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 Rhinorhino 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 JRN30

  1. JRN30

    how to create date table for comparison reporting

    Does anyone have a recommendation on the best way to create a table using dates. This is a custom table we are building in mysql. From a reporting stand point, the data will need to be compared by this year to last year and this month to last month (quarter to quarter, etc.). so a typical...
  2. JRN30

    Sub Reports

    OK, here is some background data: We are using Unidata and connect through ODBC. We are on a old version of Seagate Info: 8.0.1.1 What I am trying to do is this: Create a report, which lists Invoices and its entirety (all details of the invoice) from a selected list of part #'s. Now I need to...
  3. JRN30

    Sub Reports

    Ok I'm not sure how to respond to a previous thread, which was Filtering Data so I started a new thread. Any way, I am trying to create a Crystal sub report within a main report. I don't know how to pass the data from the main to the sub report. In the main report, I have a few parameters...
  4. JRN30

    Filtering Data

    I'm not sure if i'm doing something wrong but I kicked the report off last night and it was not finished as of this morning, so I stopped it. I basically just listed Invoice # and date in the main report. In the selection criteria, I have the part # hard coded to equal one of them and an...
  5. JRN30

    Filtering Data

    I'm not sure if i'm doing something wrong but I kicked the report off last night and it was not finished as of this morning, so I stopped it. I basically just listed Invoice # and date in the main report. In the selection criteria, I have the part # hard coded to equal one of them and an...
  6. JRN30

    Filtering Data

    I am trying to create a crystal report that will only show Invoices that contain a list of 5 part numbers. Now I need the detail on the invoice, including the designated part #'s as well as the rest of the invoice detail (other part #'s and prices). I can not just hard code and search on the...
  7. JRN30

    String is Non-Numeric

    I am new to this message board and have only worked with Crystal for a short time. Question is this: When I remove a flag from the selection criteria, which is {OEFCHEADER_1_NF.OECH_CM_FLAG} = 1.00 (it's a number field)to only show Invoice credits, it affects another formula field which is...
See more

Part and Inventory Search

Back
Top