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 phartman

  1. phartman

    missing records from linked table

    You are correct, taking the selection relating to the tx table out of the selection formula and creating the formulas with 0 suppression worked great. Thanks so much for your help!
  2. phartman

    missing records from linked table

    Sorry, I'll try to give some examples. IM TABLE DATA IM_Key IM-OHBALANCE 1234 1 1345 5 1456 9 1567 3 TX TABLE DATA TX_IMKEY TX-DATE TX-QTY 1234 07/01/04 3 1234 08/01/04 1 1345 09/01/04 2 1456...
  3. 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...
  4. phartman

    How to summarize data from 3 tables on one report

    Thank you to everyone for your input. I do not have a Oracle programmer on staff (I am the entire IT department), but I think SQL is definitely something I want to learn. I would like some assistance on refining the running totals. I'll try to provide enough sample data for you, if you need...
  5. phartman

    How to summarize data from 3 tables on one report

    The tables are linked by the job# that is in all three tables with an inner join link.
  6. 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...
  7. 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...
See more

Part and Inventory Search

Back
Top