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 dencom 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: kpetree
  • Content: Threads
  • Order by date
  1. kpetree

    Union with Null values

    I've got two tables. bmprdstr_sql is an item bill of material table and imordbld_sql is the bill of material attached to an order. I'm working on a query that will show me what items were a part of the original bill of material that are not part of the BOM attached to the order. My thought is to...
  2. kpetree

    Remove suppressed values from running total

    I have a suppression formula on the detail row that looks like this... Previous({mctrxhst_sql.ord_no})={mctrxhst_sql.ord_no} and Previous({mccrwhst_sql.oper_no})={mccrwhst_sql.oper_no} and Previous({mctrxhst_sql.trx_dt})={mctrxhst_sql.trx_dt} and...
  3. kpetree

    Remove supressed record from total

    I'm using Crystal 10 and I have a report that shows invoices due and totals them up. In the case of a duplicate invoice number is supresses the record but it still counts the supressed record in the total. How can I make the total not count the supressed records? Thanks!

Part and Inventory Search

Back
Top