Nov 28, 2005 #1 sfujii Programmer Nov 28, 2005 4 US Hi, I'm trying to get records to display horizontally all on one line separated by a comma, instead of the vertical default. Could someone help me out? NY NJ -> NY, NJ, CT CT TIA!
Hi, I'm trying to get records to display horizontally all on one line separated by a comma, instead of the vertical default. Could someone help me out? NY NJ -> NY, NJ, CT CT TIA!
Nov 28, 2005 1 #2 lbass Technical User Feb 9, 2002 32,818 US You need to accumulate the records using a formula like the following: //{@accum} to be placed in the detail section: whileprintingrecords; stringvar states := states + {table.state} + ", "; //{@display} to be placed in the footer: whileprintingrecords; stringvar states; left(states, len(states)-2) If you are accumulating for display in a group footer, then use a reset formula in the group header: whileprintingrecords; stringvar states := ""; -LB Upvote 0 Downvote
You need to accumulate the records using a formula like the following: //{@accum} to be placed in the detail section: whileprintingrecords; stringvar states := states + {table.state} + ", "; //{@display} to be placed in the footer: whileprintingrecords; stringvar states; left(states, len(states)-2) If you are accumulating for display in a group footer, then use a reset formula in the group header: whileprintingrecords; stringvar states := ""; -LB