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!

Search results for query: *

  • Users: phartman
  • Content: Threads
  • Order by date
  1. phartman

    missing records from linked table

    CR Developer 9.2.2, Oracle 9i, ODBC drivers I have 2 tables Item Master & transactions, linked (left outer join) by im_key > tx_imkey. I want the report to show all items on the item master that begin with I114 and have catalog code 114. In addition, I want all trans for these items between...
  2. phartman

    How to summarize data from 3 tables on one report

    I am running Crystal v9 Oracle database I have 3 tables The job table will have one record and contain the selling price. The labor ticket table can contain many records, one for each person/task/day, etc. The material table can contain many records, one for each piece of material used...
  3. phartman

    Records missing on report

    I have 3 files a customer file, an invoice file, and a ship to address file. Not all invoices or customers have a ship to record, only if it was shipped to a different location than the customer address. I am trying to do a sales tax report, which is based on destination state. I have a...

Part and Inventory Search

Back
Top