1 Reply Latest reply on Sep 9, 2009 7:30 PM by mrvodka

    Multiple field totals in summary report



      Multiple field totals in summary report



      When I set up my order entry many years ago, I created separate fields
      for each invoice line item (qty1, item1, qty2, item2, etc). It seems
      more efficient to do this with a portal now, but I'd still like to work

      with the data I have.

      Creating a summary field for qty1, I can get a quantity total of all products
      entered in item1 (sorted by the item number field in my product database),
      but I would like a report with the combined quantity total of all items in
      both item1 and item2.

      Is it possible to add reports or does anyone have a suggestion to accomplish this.

      Any help is appreciated.