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!

Search results for query: *

  • Users: JRN30
  • Order by date
  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...

Part and Inventory Search

Back
Top