1 Reply Latest reply: May 15, 2014 10:04 AM by Olly Bond RSS

    Multiple Column Field

    Rusch Mauzy

      I trapped the records below in a detail trap, but have two different fields in the table for product number, description, cases, and units. For instance, product numbers 2154 and 2210 appear in the table as two differing columns.

       

      I would like to trap these same fields and have the table combine the data within one filed such as product number. I.E., Product Numbers 2154 and 2210 would be captured as one field, Product Number.

       

      Please help.

       

      Thank You,

       

      Rusch

       

      [FONT=Courier New]TIME 22:37:10                                              ORDER REGISTER                                              PGM: RAP718    /FONT[/SIZE][SIZE=2][FONT=Courier New]                                                    COMPANY:   1   LOCATION:   1                                                      /FONT[/SIZE][SIZE=2][FONT=Courier New]  OPERATOR:VELOPER         ROUTE DATE:00/00/00      BRANCH: 51 MIAMI                               ROUTE:   0      CUSTOMER:     0    /FONT[/SIZE][SIZE=2][FONT=Courier New]- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -   /FONT[/SIZE][SIZE=2][FONT=Courier New]RT:  51 CUS#:815152 MIAMI TRANSFER TO RIVIERA RTE DT: 04/30/09 P ORD#:30 LODSEQ:000 TYPE:BRANCH           LOAD #:                     /FONT[/SIZE][SIZE=2][FONT=Courier New]P.O.#:LIVELOAD THUR          NULL: No         WAR DT: 04/30/09 TICKET:  45851557  DELV DT:  04/30/09  OP: VREAPB      BRANCH:  51     /FONT[/SIZE][SIZE=2][FONT=Courier New] PRODUCT NUMBER & DESCRIPTION         UNITS       CASES      PRODUCT NUMBER & DESCRIPTION         UNITS       CASES                  /FONT[/SIZE][SIZE=2][FONT=Courier New]    2154 SH FRESH 1%     GAL              72          18        2210 DF 1%           GAL             144          36                  /FONT[/SIZE][SIZE=2][FONT=Courier New]    4016 VF 2%           GAL             600         150        4022 VF 1%           GAL              96          24                  /FONT[/SIZE][SIZE=2][FONT=Courier New]    4030 2% SLM PK       HPT           1,200          24        4048 VF SKIM         GAL             240          60                  /FONT[/SIZE][SIZE=2][FONT=Courier New]    4129 DF SKIM         GAL             504         126        4154 SH FRESH SKIM   GAL              24           6                  /FONT[/SIZE][SIZE=2][FONT=Courier New]   10110 LF CHO SLM .5%  HPT           2,700          54       19058 CRWLY SOUR CREA 8OZ              72           6                  /FONT[/SIZE][SIZE=2][FONT=Courier New]   25030 DQ 5% VAN MIX   5GL              40          40       29311 SOL TROP ORG JU HGL              54           6                  /FONT[/SIZE][SIZE=2][FONT=Courier New]   29312 SOL TROP ORG JU PT              120           6       31213 CW 4% LG CTG/CH 16OZ             48           4                  /FONT[/SIZE][SIZE=2][FONT=Courier New]   49631 YPLAT STRAW SMT 8OZ              72           6       49632 YPLAT MIX BRY S 8OZ              72           6                  /FONT[/SIZE][SIZE=2][FONT=Courier New]                                                                                TOTALS            7,983       1,057                  /FONT[/SIZE][/code]

        • Multiple Column Field
          Olly Bond

          Dear Rusch,

           

          You might find the easiest way to get your data grouped as you would like it is to make a summary.

           

          Alternatively, the multi-column region setting in the Templates menu in the Report window should help. Your sample report got garbled - feel free to email me that as an attachment if you can, and I'll suggest which route might be best.

           

          Best wishes,

           

          Olly