Search results for query: *

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!

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...

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...

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...

The tables are linked by the job# that is in all three tables with an inner join link.

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...

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...