• How to get Crystal Reports to Pull Data from 2 Unrelated Tables and Summarize Them

    I have a crystal report that is pulling data from our posted AR_InvoiceHistoryHeader and AR_InvoiceHistoryDetail files and I have the exact same report pulling data from our un-posted SO_InvoiceHeader and SO_InvoiceDetail tables. I want to have the two…
  • How to Sort a Crystal Report by Positive or Negative Summary Fields and also by Item Number

    I have a crystal report that is pulling data from our posted AR_InvoiceHistoryHeader and AR_InvoiceHistoryDetail files. I want to have it subtotal the quantities of each of the products and then print all items with a negative number on one page and all…